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 the difference between odbc and drs stage?
Where do you see different stages in the designer?
What is datastage?
What are the types of jobs we have in datastage?
Name the third party tools that can be used in datastage?
What is the difference between the local container and shared container?
How rejected rows are managed in datastage?
What is a ds designer?
What are stage variables and constants?
What is a quality stage in datastage tool?
Explain Quality stage?
How do you import and export data into datastage?
Name the different types of Lookups in Datastage?
what are the errors,warnings in datastage
Describe the main features of datastage?