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
- 6531 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
How to reverse the string using unix?
Is possible to create skid in dim,fact tables?
Explain ibm infosphere information server and highlight its main features?
in oracle target stage when we use load option and when we use upsert option?
Can you filter data in hashed file?
Explain connectivity between datastage with datasources?
What is the flow of loading data into fact & dimensional tables?
What are the main features of datastage?
how to abort the job its matain duplicates?
How do you import and export data into datastage?
Could anyone give brief explanation bout datastage admin
How can we improve performance of data stage jobs?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What are stage variables?
What is data partitioning?
