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
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What is the purpose of pivot stage and types of containers in datastage
What is a merge in datastage?
What are the types of containers?
What is a quality stage in datastage tool?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Explain how a source file is populated?
What are the job parameters?
If you want to use a same piece of code in different jobs, how will you achieve this?
What are the functionalities of link collector?
What is staging variable?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What are the types of views in datastage director?
project Steps,hits, Project level HArd things,Solved methods?
What is the difference between server job and parallel jobs?