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
- 14960 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
Lookup constraints
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?
what is ds administrator used for?
What is the difference between the local container and shared container?
What is the purpose of interprocessor stage in server jobs?
How to reverse the string using SQL?
Differentiate between operational datastage (ods) and data warehouse?
Differentiate between odbc and drs stage?
What is the difference between in process and inter process?
How do you schedule or monitoring the job?
What is the difference between account and directory options ?
how to write server Routine coding?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
what are the errors,warnings in datastage
What are the difference types of stages?
