hi this is kiran
i have one table i want divide the table with two different
table like even rows and odd rows
how can i do this one
tell me plzz
Answer Posted / srinu
sourc->transformer->filter->two targets
in the transformer stage we have append new column and
derviation area write mod(@outrownum,2) (where @outrownum in
sysvarible)
after that we put fileter or switch in that
write condition on append column 0 then even records
1 then go odd records
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is quality stage?
Describe the architecture of datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are the job parameters?
What is the precedence of stage variables,derivations, and constraints?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is a quality stage in datastage tool?
What is the difference between Datastage 7.5 and 7.0?
Explain Quality stage?
how to abort the job its matain duplicates?
Name the command line functions to import and export the DS jobs?
What are the different type of jobs in datastage?
Can you implement SCD2 using join, transformer and funnel stage?
How to perform incremental load in datastage?
table actions available in oracle connector?