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
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 is "fatal error/rdbms code 3996" error?
What are system variables and sequencers in datastage
how to abort the job its matain duplicates?
Notification Activity
what is the custome stage in datastage? how can we impliment that one? plz tell me
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
How many types of views are there in a datastage director?
Differentiate between data file and descriptor file?
root tree will find which is server job and which is parallel job?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
How can you write parallel routines in datastage PX?
What is a merge?
How do you run datastage job from the command line?
What is usage analysis in datastage?