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
How do you reject records in a transformer?
What is the difference between an operational datastage and a data warehouse?
What are the types of containers?
Define Merge?
What is a ds designer?
why do u need the IOS upgradation in a FC switch
What are the steps needed to create a simple basic datastage job?
Can you explain link buffering?
Describe stream connector?
How a source file is populated?
How to read the length of word in unix?
How to read multiple files using a single datastage job if files have the same metadata?
How to convert RGB Value to Hexadecimal values in datastage?
Name the different sorting methods in datastage.
What is the process of killing a job in datastage?