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
What are transforms and what is the differenece between routines and transforms?
What are stage variables?
How a routine is called in datastage job?
What is the difference between datastage and informatica?
How rejected rows are managed in datastage?
Can you filter data in hashed file?
How to read the length of word in unix?
Can you highlight the main features of ibm infosphere information server?
What are the types of containers and how to create them?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
How will you move hashed file from one location to another location?
What is the use of hoursfromtime() function in transformer stage in datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
how to export or import the jobs in .ISX file