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
- 19101 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
What is the difference between in process and inter process?
Explain ibm infosphere information server and highlight its main features?
How can we improve performance of data stage jobs?
Where the datastage stored his repository?
What is a merge?
How to implement complex jobs in data stage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How do you generate sequence number in datastage?
What is the purpose of interprocessor stage in server jobs?
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 orabulk and bcp stages?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
how do u catch bad rows from OCI stage? And what CLI stands for?
What are the different common services in datastage?
