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
Answers were Sorted based on User's Feedback
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 |
Answer / 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 |
Answer / sekhar
Use Full outer join and propagate left and right links into transformer.If records are not matched nulls will be populated.Identify nulls in both left and right links you will get two target and for third target just write in Contraints-isnotnull(leftlink and rightlink)-Target 2
-Isnull(leftlink.Inputcolumn)-Target1
-Isnull(Rightlink.Inputcolumn)-Target3
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / prabhu rathnam
Seq1,Seq2--->join--->removeduplicate---->filter--->trg1,trg2,trg3
Is This Answer Correct ? | 0 Yes | 0 No |
What are the types of containers in datastage?
What are stage variables, derivations and constants?
Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain
cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle
How can we improve performance of data stage jobs?
How can we run same job in 1 day 2 times
i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance
how to call sequential generator in datastage?
how to design the change capture stage in(data stage parallel jobs) type 2