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 / subhash
Using change capture stage:
File1(Master),File2----> change capture---> Filter ---->
T1, T2, T3
In Filter,
Change_code=1 then send then to T1-->(Insert records)
Change_code=0 then send then to T2-->(Copy records)
Change_code=2 then send then to T3-->(Delete records)
Is This Answer Correct ? | 24 Yes | 1 No |
Post New Answer View All Answers
What is the difference between passive stage and active stage?
How many types of views are there in a datastage director?
Name the command line functions to import and export the DS jobs?
What is the different type of jobs in datastage?
what is the use of surogate key in datastage
What is the flow of loading data into fact & dimensional tables?
what is the use of skid in reporting?
What are stage variables?
which r the connectors used in san?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What are the different type of jobs in datastage?
Can you explain how could anyone drop the index before loading the data in target in datastage?
How to reverse the string using unix?
what is repositery?
What a datastage macro?