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
- 13717 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
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
How will you move hashed file from one location to another location?
Distinguish between informatica & datastage. Which one would you choose and why?
What are the different plug-ins stages used in your projects?
What are the different type of jobs in datastage?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
How do you remove duplicate values in datastage?
What are stage variables and constants?
how can we create rank using datastage?what is the meaning of rank?
how to implement scd2 in datastage 7.5 with lookup stage
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are the types of containers in datastage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Give an idea of system variables.
What are the different types of lookups in datastage?
