1) Source file come with header,footer and along with not related lines in the file between records. (using tfileinputfullrow ,tfilter and extractdelimeitedfiled done)
2) Single records come with multiple lines 2,3 or 4 lines some records. (tmap done)
3) based on records need to split columns.Some contains space, multiple space and no fixed length for columns.(not done)
Hints:
1) Records start with digit, we need to pick only 2 lines which lines start with digits.
2) Need to concatenate 2 lines into single line.
3) remove space and split fields and store into database.
My design:
Step 1 and step 2 i have resolved. Problem my facing with spaces.
