Please provide best approach to design ETL in Oracle. [message #657846] |
Thu, 24 November 2016 06:23 |
|
msol25
Messages: 396 Registered: June 2011
|
Senior Member |
|
|
Hello Friends,
I need to design ETL from scratch.In this data is coming from multple sources in different landing locations and needs to load into oracle tables for a specific schema.Total size for the data will be around 700-800 MB(including all the sources).
I have approaches in mind to load data using external tables or load data through Sqlldr.I need to know which approach is better to design ETL.
Please share the experience.
Sorry to bear me !!!
Thanks
msol25
|
|
|
|
|
|
Re: Please provide best approach to design ETL in Oracle. [message #657850 is a reply to message #657846] |
Thu, 24 November 2016 07:20 |
John Watson
Messages: 8938 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I think you are asking which of External Tables or SQL Loader is the optimum tool. I have no idea which is better for your purposes, though your comment regarding "different landing locations" may be relevant. You'll need to conduct an analysis of the requirement. Or pay someone to do it for you.
|
|
|