Seq1,Seq2--->join--->removeduplicate---->filter--->trg1,trg2,tr

file1
1
2
3
4
file2
3
4
5
6

output should be in three targets
T1 T2 T3
1 3 5
2 4 6

how to do this? can any one help?

Thanks

Question Posted / prabhu rathnam

5 Answers
13861 Views
Cap Gemini, I also Faced
E-Mail Answers

Answer Posted / prabhu rathnam

Seq1,Seq2--->join--->removeduplicate---->filter--->trg1,trg2,trg3

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a merge in datastage?

1343

How do y read Sequential file from job control?

16079

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4098

What is the different type of jobs in datastage?

1030

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5192

how to write server Routine coding?

2181

What are the benefits of datastage?

1301

What are the difference types of stages?

1287

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

1604

What is job control?

1198

What a datastage macro?

1102

How many types of views are there in a datastage director?

1340

CHANGE CAPTURE

1353

What steps should be taken to improve Datastage jobs?

1120

How the ipc stage work?

1170