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


Please Help Members By Posting Answers For Below Questions

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2742


How to RD using transformer?

857


Different ways a project can be moved to production ?...example ….export-import and Version control.

1931


what are the errors,warnings in datastage

2145


What is the sortmerge collector?

660






in oracle target stage when we use load option and when we use upsert option?

1748


What are the different common services in datastage?

705


What are the important features of datastage?

616


Name the different sorting methods in datastage.

609


How to find value from a column in a dataset?

1767


What is the difference between Datastage 7.5 and 7.0?

671


Terminate Activity

837


What can we do with datastage director?

666


What is meta stage?

577


Explain how a source file is populated?

759