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

Answer Posted / yuvraj

This can be done using change capture stage:

Seq1,Seq2 ----> change capture (here keep Drop Output for
copy : False) ---> Filter ----> seq1,seq2,seq3

from this above output will get

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are transforms and what is the differenece between routines and transforms?

611


What are stage variables?

636


How a routine is called in datastage job?

603


What is the difference between datastage and informatica?

609


How rejected rows are managed in datastage?

915






Can you filter data in hashed file?

3341


How to read the length of word in unix?

882


Can you highlight the main features of ibm infosphere information server?

635


What are the types of containers and how to create them?

556


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

4558


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2424


How will you move hashed file from one location to another location?

1655


What is the use of hoursfromtime() function in transformer stage in datastage?

582


1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

1801


how to export or import the jobs in .ISX file

714