We can achieve this by using Change data capture stage as comparing the 2

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?

Question Posted / sreenivas ramanathan

11 Answers
19092 Views
CTS, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What is the roundrobin collector?

1151

What is the command line function to import and export the ds jobs?

1193

how do u catch bad rows from OCI stage? And what CLI stands for?

2853

What is difference between join, merge and lookup stage?

1151

What is the difference between orabulk and bcp stages?

1076

What is the difference between passive stage and active stage?

1648

What is difference between server jobs & parallel jobs?

1091

Terminate Activity

1339

How complex jobs are implemented in datstage to improve performance?

1096

What all the types of jobs you developed?

1248

EXPLAIN SCD

1450

What is the project in datastage?

1167

What is a merge in datastage?

1345

Explain entity, attribute and relationship in datastage?

1157

Define Merge?

1374