Bringing source file name over with the column data

swathitagore · Post by **swathitagore** » Thu Jan 05, 2012 2:30 pm

Using DataStage Designer 8.7 within a parallel job, while reading sequential source files using pattern matching for the file name how do I bring the source file name over with the column data?

ray.wurlod · Post by **ray.wurlod** » Thu Jan 05, 2012 2:48 pm

There is an optional property called something like "source file name column".

swathitagore · Post by **swathitagore** » Thu Jan 05, 2012 3:34 pm

We found that option but it's only giving back pattern matching instead of full file name.

For example: adrlanding/CMS/MMR/*.MONMEMD.*

SURA · Post by **SURA** » Thu Jan 05, 2012 4:38 pm

Find out the APT_IMPORT_PATTERN* env variable and add it.

DS User

nagarjuna · Post by **nagarjuna** » Sat Jan 07, 2012 12:59 pm

You can include filename property ( which gets enables when you use file pattern ) & make sure that you are setting that env variable as suggested by sura

chulett · Post by **chulett** » Sat Jan 07, 2012 2:55 pm

$APT_IMPORT_PATTERN_USES_FILESET=TRUE