HOW CAN WE ABORT THE JOB IF THE DATA IS DUPLICATE?
Datastage scenarios
Tuesday, 14 August 2012
scenario 5
A sequential file has 8 records with one column, below are
the values in the column separated by space,
1 1 2 2 3 4 5 6
output-
File 1 records separated by space: 1 1 2 2
File 2 records separated by space: 3 4 5 6
scenario 4
Input is like this:
file1
10
20
10
10
20
30
Output is like:
file2
file3(duplicates)
10
10
20 10
30 20
scenario 3
Input is like this :
i/p
col1,col2
101,a
102,b
103,c
104,d
Output need to be:
o/p
col1,col2
101,d
102,c
103,b
scenario 2
Input -
id code
111 01,02,03
222 04,05
Expected output -
id code
111 01
111 02
111 03
222 04
222 05
Subscribe to:
Posts (Atom)