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 / sreenivas ramanathan
We can achieve this by using Change data capture stage as comparing the 2 inputs.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define Job control?
what is repositery?
What is a quality stage in datastage tool?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Is the value of staging variable stored temporarily or permanently?
What is usage analysis in datastage?
Explain connectivity between datastage with datasources?
What steps should be taken to improve Datastage jobs?
What are some prerequisites for datastage?
Notification Activity
how to abort the job its matain duplicates?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Define repository tables in datastage?
What are the functionalities of link collector?