Complex Flat File
Posted: Wed Feb 13, 2008 10:13 pm
Hi ,
I am using complex Flat file for reading multiple records types within a same file .
The file is as follows
GHIJKLABCD20070918ZX
MNOPQREFGHI20070917JAHALHALJJKAHKHAKHA
------------------------------
Inabove file , the fields are as follows
1 2 3 4
GHIJKL ABCD 20070918 ZX ----- ( FIRST LINE WITH 4 FIELDS NO
SEPARATOR )
1 2 3 4 5 6
MNOPQR EFGH 20070917 JAHAL HALJJKAH KHAKHA ---- ( 2ND LINE WITH 6 fields with no separator )
Like that there are many records with different metadata.For reading this file I am using CFF parallel job .
I gave recordid constraint as GHIJKL for first record and
MNOPQ for second record.
I gave metadata for each record properly.I am directing each record to a sequential file .But in the o/p I am able to view data for only 1st recordid.Can anyone suggest the exact procedure ?
Can I direct all the records in the file with same recordid ( like MNOPQR ) to one sequential file using CFF ?
I am using complex Flat file for reading multiple records types within a same file .
The file is as follows
GHIJKLABCD20070918ZX
MNOPQREFGHI20070917JAHALHALJJKAHKHAKHA
------------------------------
Inabove file , the fields are as follows
1 2 3 4
GHIJKL ABCD 20070918 ZX ----- ( FIRST LINE WITH 4 FIELDS NO
SEPARATOR )
1 2 3 4 5 6
MNOPQR EFGH 20070917 JAHAL HALJJKAH KHAKHA ---- ( 2ND LINE WITH 6 fields with no separator )
Like that there are many records with different metadata.For reading this file I am using CFF parallel job .
I gave recordid constraint as GHIJKL for first record and
MNOPQ for second record.
I gave metadata for each record properly.I am directing each record to a sequential file .But in the o/p I am able to view data for only 1st recordid.Can anyone suggest the exact procedure ?
Can I direct all the records in the file with same recordid ( like MNOPQR ) to one sequential file using CFF ?