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
Lookup constraints
Have you used Unstructured data?
Nls stands for what in datastage?
what is use of SDR function?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
How you can fix the truncated data error in datastage?
Differentiate between datastage and informatica?
What are constraints and derivations?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What all are the different way to run a job?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
Define ds designer?
Why fact table is in normal form?
Difference between in process and inter process?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do