my source seq file have
col1
1
2
3
4
5
6
7
8
9
i have 4 targets
t1 t2 t3 t4
1 2 3 4
5 6 7 8
9 like this how we can get?
Answer Posted / abd
We can use stage variable in Tran Stage
IF @INROWNUM MOD 4 = 0 then T4
Else If @INROWNUM MOD 4 = 1 then T1
Else If @INROWNUM MOD 4 = 2 then T2
Else If @INROWNUM MOD 4 = 3 then T3
Try this
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
Why do we use exception activity in Datastage?
how can we create rank using datastage?what is the meaning of rank?
Which algorithm you used for your hashfile?
What all the types of jobs you developed?
What is "fatal error/rdbms code 3996" error?
Define meta stage?
What is the purpose of pivot stage?
Terminate Activity
what is flow of project?
What is use Array size in datastage
How to implement complex jobs in data stage?
What are the different layers in the information server architecture?
Describe link sort?
If you want to use the same piece of code in different jobs, how will you achieve it?
On which Dimension Table you implemented SCD Type in your Project