Home » SQL & PL/SQL » SQL & PL/SQL » Please provide best approach to design ETL in Oracle. (Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production)
Please provide best approach to design ETL in Oracle. [message #657846] Thu, 24 November 2016 06:23 Go to next message
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 #657847 is a reply to message #657846] Thu, 24 November 2016 06:54 Go to previous messageGo to next message
Roachcoach
Messages: 1571
Registered: May 2010
Location: UK
Senior Member
This will probably sound blunt, but you want to be paying for a consultant.
Re: Please provide best approach to design ETL in Oracle. [message #657848 is a reply to message #657847] Thu, 24 November 2016 07:13 Go to previous messageGo to next message
msol25
Messages: 396
Registered: June 2011
Senior Member
Hi Roachcoach,

Sorry to bear me !!!

I have to decide which approach is better to develop the ETL and will go accordingly for that as a baseline.

Re: Please provide best approach to design ETL in Oracle. [message #657849 is a reply to message #657848] Thu, 24 November 2016 07:19 Go to previous messageGo to next message
BlackSwan
Messages: 26208
Registered: January 2009
Location: SoCal
Senior Member
so benchmark the alternatives so measure for yourself which runs faster.
Re: Please provide best approach to design ETL in Oracle. [message #657850 is a reply to message #657846] Thu, 24 November 2016 07:20 Go to previous message
John Watson
Messages: 7624
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.
Previous Topic: SQL Query Update
Next Topic: Trigger to prevent delete according to select
Goto Forum:
  


Current Time: Wed Oct 24 00:38:21 CDT 2018