Need Help on job design.
Posted: Mon May 27, 2013 8:15 am
Experts,
Please help me to design a parallel job for the below scenario.
Source:
-------------------------------------------
H|file1.txt|20130526
D|123|456|789|012
D|345|678|901|234
.
.
T|0987
H|file2.txt|20130526
D|000|56W|789|Q12
D|000|67E|9E1|W34
.
.
T|1234
-------------------------------------------
Target file1:
H|file1.txt|20130526
D|123|456|789|012
D|345|678|901|234
.
.
T|0987
Target file2:
H|file2.txt|20130526
D|000|56W|789|Q12
D|000|67E|9E1|W34
.
.
T|1234
The source file can contain set of, any no of Header/Detail/Trailer records.
we need separate it into a individual files and load into a table.
Thanks
Dinesh
Please help me to design a parallel job for the below scenario.
Source:
-------------------------------------------
H|file1.txt|20130526
D|123|456|789|012
D|345|678|901|234
.
.
T|0987
H|file2.txt|20130526
D|000|56W|789|Q12
D|000|67E|9E1|W34
.
.
T|1234
-------------------------------------------
Target file1:
H|file1.txt|20130526
D|123|456|789|012
D|345|678|901|234
.
.
T|0987
Target file2:
H|file2.txt|20130526
D|000|56W|789|Q12
D|000|67E|9E1|W34
.
.
T|1234
The source file can contain set of, any no of Header/Detail/Trailer records.
we need separate it into a individual files and load into a table.
Thanks
Dinesh