Interested to Buy Any Domain ? << Click Here >> for more details...
Input file one has data as shown below
1
2
3
4
5
6
7
8
Input file two has data like
6
7
8
9
10
11
Design a data stage job which will provide me three output files as shown below:
Output 1
6
7
8
Output 2
1
2
3
4
5
Output 3
9
10
11
Let me know your answers
- 4 Answers
- 6576 Views
- IBM, PR3 Systems, I also Faced
- E-Mail Answers
Answer Posted / pavani
by using join type=full outer.we have to get output has 2 columns. 1st_column values are first inputs and remaining nulls,2_column values are second input and remaining are nulls.
then by using transformer write a constraint
1.output----->1st_column=2_column;
2.output----->2_column=null or'';(depending on input data)
3.output----->1st_column=null or'';(depending on data)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are the some differences between 7.x and 8.x version of datastage?
What are system variables and sequencers in datastage
Can you explain kafka connector?
how to add a new records into source?
what is the use of skid in reporting?
Difference between server jobs & parallel jobs?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
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 to reverse the string using unix?
What is the purpose of interprocessor stage in server jobs?
Why do we use link partitioner and link collector in datastage?
What are the types of jobs we have in datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What is the difference between the local container and shared container?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
