Home » Developer & Programmer » Data Integration » load data (oracle 10g)
load data [message #303229] Thu, 28 February 2008 08:15 Go to next message
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Can any one pls tell me the difference between, using the " import metadata wizard" and "SQL*Loader". How can i load the actual data into a table? do i have to create the new table in the OWB first and then use the SQL*Loader? Please can any one explain me the above problems.

Re: load data [message #310286 is a reply to message #303229] Mon, 31 March 2008 18:18 Go to previous message
Messages: 82
Registered: October 2007
meta data means : information about your objects.

sql*loader is used to load data from flat files to tables. but not meta data.

to load data from tables you have to create mapping and deploy the map and execute the map. after executing of your map OWB automatically loads data from source to target

Previous Topic: Assign constant value for one column at target table
Next Topic: Problem running a XML-Load within OWB10.2.0.2
Goto Forum:

Current Time: Sun Aug 20 03:00:44 CDT 2017

Total time taken to generate the page: 0.07450 seconds