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
What are the types of views in datastage director?
client know skid info?
What is the difference between informatica and datastage?
how to write server Routine coding?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
CHANGE CAPTURE
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is the process of killing a job in datastage?
how to delete one row in target dataset
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What is the flow of loading data into fact & dimensional tables?
Difference between sequential file and data set?
Difference between data warehousing and olap?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?