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
- 18774 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
how to abort the job its matain duplicates?
How rejected rows are managed in datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What are constraints and derivations?
What is the difference between hashfile and sequential file?
What are the different common services in datastage?
What is size of a transaction and an array means in a datastage?
Is it possible to query a hash file?
What is use Array size in datastage
In Datastage, how you can fix the truncated data error?
Difference between sequential file and data set?
how do u catch bad rows from OCI stage? And what CLI stands for?
How to reverse the string using unix?
I have a few records just I want to store data in to targets cycling way how?
Have you used Unstructured data?
