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
- 18751 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
What are the features of datastage flow designer?
What is the difference between odbc and drs stage?
Define project in datastage?
sed,awk,head
What are constraints and derivations?
how to sort two columns in single job in datastage.
Which algorithm you used for your hashfile?
What is the difference between passive stage and active stage?
Where do you see different stages in the designer?
What is the difference between datastage and informatica?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are the functionalities of link partitioner and link collector?
What are the processing stages?
Differentiate between Join, Merge and Lookup stage?
What is the use of datastage director?
