Interested to Buy Any Domain ? << Click Here >> for more details...
INPUT file 'A' contains:
1
2
3
4
5
6
7
8
9
10
input file 'B' contains:
6
7
8
9
10
11
12
13
14
15
Output file 'X' contains:
1
2
3
4
5
Output file 'Y' contains:
6
7
8
9
10
Output file 'Z' contains:
11
12
13
14
15
How can we implement this in a single ds job?
- 11 Answers
- 18622 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / noothan
This is another option for implementing the same.
Implement a full outer join with File A as Left and File B
as right. Let the output contain Col_File_A from file A and
Col_File_B from file B. Pass this output through a filter
stage with the filter condition as below.
Col_File_B is null= file x
Col_File_B is not null and Col_File_A is not null = file Y
Col_File_A is null= file Z.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Where do you see different stages in the designer?
What are the primary usages of datastage tool?
What is the precedence of stage variables,derivations, and constraints?
What are datastage sequences?
What is difference between join, merge and lookup stage?
How can you write parallel routines in datastage PX?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
what is use of SDR function?
What steps should be taken to improve Datastage jobs?
What is the purpose of interprocessor stage in server jobs?
What is ds designer?
What is ibm datastage flow designer?
Difference between server jobs & parallel jobs?
What are the job parameters?
What is the difference between in process and inter process?
