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
- 18274 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / huma
Why're we complicating the solution. Simple use merge stage. Output Y will be result of merge (inner join) while rest all will be the rejected outputs from update link.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
explain about citrix scheduling tool in datastage
Triggers,VIEW,Procedures
What is the difference between an operational datastage and a data warehouse?
What are the various kinds of the hash file?
CHANGE CAPTURE
Difference between sequential file and data set?
What is a merge?
What is the difference between informatica and datastage?
How to convert RGB Value to Hexadecimal values in datastage?
how can we create rank using datastage?what is the meaning of rank?
Can you explain how could anyone drop the index before loading the data in target in datastage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Name the different types of Lookups in Datastage?
What is the difference between the local container and shared container?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
