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?
Answer Posted / 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 |
Post New Answer View All Answers
What are some prerequisites for datastage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
How to clean the datastage repository?
what is 'reconsideration error' and how can i respond to this error and how to debug this
How to reverse the string using SQL?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Define repository tables in datastage?
explain about citrix scheduling tool in datastage
Does datastage support slowly changing dimensions ?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
How and where you used hash file?
What are the functionalities of link collector?
What are stage variables, derivations and constants?
What is the differentiate between data file and descriptor file?