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
- 19089 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 errors,warnings in datastage
What is the command line function to import and export the ds jobs?
Define Data Stage?
Why do you need stage variables?
in oracle target stage when we use load option and when we use upsert option?
Name the different types of Lookups in Datastage?
What is a folder? Difference types of stages?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
what is the use of surogate key in datastage
how to delete one row in target dataset
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Define oconv () and iconv () functions in datastage?
what is the difference between == and eq in UNIX shell scripting?
Differentiate between datastage and datastage tx?
How do you schedule or monitoring the job?
