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
- 18594 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / reddymkl.dwh
Use Full outer join
Right ------------->X table
| |
| |
Left--> Join----->Filter---------->Y table
|
|
Z table
Left.colname=Right.colname
Right.colname='' (A-B)
Left.colname<>'' and Right.colname<>'' (A intersection B)
Left.colname<>'' (B-A)
Will get desired output
Please correct if am wrong....
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to abort the job its matain duplicates?
What is the method of removing duplicates, without the remove duplicate stage?
Why do we use link partitioner and link collector in datastage?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is the difference between validated and compiled in the datastage?
Define data aggregation?
What is the roundrobin collector?
What is difference between join, merge and lookup stage?
What are the differences between datastage and informatica?
What is a merge in datastage?
Explain the situation where you have applied SCD in your project?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What all are the different way to run a job?
What is the difference between an operational datastage and a data warehouse?
What is orabulk stage?
