I have oracle enterpaise stage, oracle bulkloader stage,
ODBC stage and I want to load data in to target, which of
the above stages do I need to use and why?
Answers were Sorted based on User's Feedback
Answer / vijaya
Hi
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 bulkloader stage.Oracle enterprise is faster as
compare to ODBC.oracle enterprise runs parallel where as
ODBC runs seq.
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / ravi kumar
oracle enterpaise stag is best becs we can use develope any
one.
Is This Answer Correct ? | 3 Yes | 0 No |
What is ibm datastage flow designer?
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises
what is the Difference Between Datastage Server Edition and Parallel Edition?
how to identifie,is it innerjoin,leftouter join in lookup?
How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.
Why do we use exception activity in Datastage?
A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
Does datastage support slowly changing dimensions ?
What is the difference between validate and compile?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how