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 / 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 |
Post New Answer View All Answers
What is the command line function to import and export the ds jobs?
Define Job control?
What is the roundrobin collector?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is the difference between orabulk and bcp stages?
Demonstrate experience in maintaining quality process standards?
Can you explain tagbatch restructure operator?
How to manage date conversion in Datastage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Can you explain link buffering?
How rejected rows are managed in datastage?
Enlist various types of routines in datastage.
Differentiate between operational datastage (ods) and data warehouse?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do