Tuesday, 14 August 2012

scenario 6


HOW CAN WE ABORT THE JOB IF THE DATA IS DUPLICATE?

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

sccenario 1



In source i have only one record.I want 10 records(same record will repeat) in target.