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
How many types of sorting methods are available in datastage?
How a server job can be converted to a parallel job?
How can one find bugs in job sequence?
In Datastage, how you can fix the truncated data error?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What is ds designer?
How can we improve performance of data stage jobs?
What are the different common services in datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
How to read multiple files using a single datastage job if files have the same metadata?
explain about citrix scheduling tool in datastage
Where do you see different stages in the designer?
What is the difference between datastage and datastage tx?
EXPLAIN SCD
How to reverse the string using SQL?