Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 13863 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 are the different plug-ins stages used in your projects?
What is the process of killing a job in datastage?
What is the purpose of interprocessor stage in server jobs?
What are transforms and what is the differenece between routines and transforms?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
how to export or import the jobs in .ISX file
How we can covert server job to a parallel job?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
what is ds administrator used for?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
how to implement scd2 in datastage 7.5 with lookup stage
How many types of stage?
What are constraints and derivations?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
Name the command line functions to import and export the DS jobs?
