Invalid Filenames using File Name Column property
Posted: Fri Aug 20, 2010 3:39 am
Hi Gurus,
I am reading multiple files using the file pattern property in a sequential file stage. I am fetching the filenames using the File Name column property. I am also setting the Environment variable $APT_IMPORT_PATTERN_USES_FILESET=TRUE.
I am able to fetch the filenames for each record read. But the filename associated with each record are not as per the actual.
e.g
File1 - 10 rec
File2 - 10 rec
File3 - 10 rec.
I am reading 30 records in the stage. But I get 1 record with File1 as the filename. 10 records with File2 and the rest with File3. So File1 is being overwritten with File3.
Additional Info:
No. of Nodes - 2
Sever Version - 7.5.2
Client Verison - 7.5.1.A
Os - AIX
Thanks
I am reading multiple files using the file pattern property in a sequential file stage. I am fetching the filenames using the File Name column property. I am also setting the Environment variable $APT_IMPORT_PATTERN_USES_FILESET=TRUE.
I am able to fetch the filenames for each record read. But the filename associated with each record are not as per the actual.
e.g
File1 - 10 rec
File2 - 10 rec
File3 - 10 rec.
I am reading 30 records in the stage. But I get 1 record with File1 as the filename. 10 records with File2 and the rest with File3. So File1 is being overwritten with File3.
Additional Info:
No. of Nodes - 2
Sever Version - 7.5.2
Client Verison - 7.5.1.A
Os - AIX
Thanks