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?
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
how do u catch bad rows from OCI stage? And what CLI stands for?
What are the features of datastage flow designer?
How to reverse the string using unix?
What is ds designer?
Explain entity, attribute and relationship in datastage?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
How to find value from a column in a dataset?
Explain connectivity between datastage with datasources?
What is the difference between an operational datastage and a data warehouse?
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 are the types of containers?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is a ds designer?
What is aggtorec restructure operator?
Distinguish between informatica & datastage. Which one would you choose and why?