load data [message #303229] |
Thu, 28 February 2008 08:15 |
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 |
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
|
|
|