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
- 19095 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
What is the process of killing a job in datastage?
How do y read Sequential file from job control?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
How do you reject records in a transformer?
Describe the main features of datastage?
How a server job can be converted to a parallel job?
How many types of hash files are there?
how to implement scd2 in datastage 7.5 with lookup stage
Define orabulk and bcp stages?
Demonstrate experience in maintaining quality process standards?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Can you filter data in hashed file?
What are the features of datastage flow designer?
What are the stages in datastage?
What are the different types of lookups in datastage?
