Home > Software > Data-Warehouse > DataStage
Interview Questions   Tutorials   Discussions   Programs   Discussion   

DataStage - I have oracle enterprise stage, oracle bulk loader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?




748
views
asked mar September 20, 2014 06:31 AM  

I have oracle enterprise stage, oracle bulk loader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?


           

1 Answers



 
answered By vishnoiprem   0  
Its all depends on the source data if the data is coming
through oracle datastage then go for oracle enterprise stage
if it a incremental load but if it is initial load then go
for oracle bulk loader stage.
Oracle enterprise is faster as compare to ODBC.
oracle enterprise runs parallel where as ODBC runs seq.  
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert