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: Performance issues in OWB
Next Topic: error while redeploying
Goto Forum:

Current Time: Thu May 23 22:17:33 CDT 2024