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
What is apt_config in datastage?
How to read multiple files using a single datastage job if files have the same metadata?
What are the different options associated with dsjob command?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Triggers,VIEW,Procedures
Explain the importance of surrogate key in data warehousing?
what is the use of surogate key in datastage
What all are the different way to run a job?
What is the difference between datastage and informatica?
What are the types of containers and how to create them?
client know skid info?
How the ipc stage work?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How do you reject records in a transformer?
What are the functionalities of link partitioner and link collector?