Home » Developer & Programmer » Data Integration » load data (oracle 10g)
load data [message #303229] Thu, 28 February 2008 08:15 Go to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Hi
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.


Thanks
Re: load data [message #310286 is a reply to message #303229] Mon, 31 March 2008 18:18 Go to previous message
skumar.dba
Messages: 82
Registered: October 2007
Member
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

Regards,
Kumar
Previous Topic: Performance issues in OWB
Next Topic: error while redeploying
Goto Forum:
  


Current Time: Thu Dec 12 05:58:17 CST 2024