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 |
How do y read Sequential file from job control?
1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
What is a range lookup?
source file contains 100 records, i want 10 records in target file how it possible in datastage
on how many columns we can perform aggregation in the Aggregator stage?
If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
what r the sources u need to create the datastage?
1)Source file contains one record, I want 100 records in target file.
What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
How do you run datastage job from the command line?
eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.