Page 1 of 1

Bringing source file name over with the column data

Posted: Thu Jan 05, 2012 2:30 pm
by swathitagore
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?

Posted: Thu Jan 05, 2012 2:48 pm
by ray.wurlod
There is an optional property called something like "source file name column".

Posted: Thu Jan 05, 2012 3:34 pm
by swathitagore
We found that option but it's only giving back pattern matching instead of full file name.

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

Posted: Thu Jan 05, 2012 4:38 pm
by SURA
Find out the APT_IMPORT_PATTERN* env variable and add it.

DS User

Posted: Sat Jan 07, 2012 12:59 pm
by nagarjuna
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

Posted: Sat Jan 07, 2012 2:55 pm
by chulett
$APT_IMPORT_PATTERN_USES_FILESET=TRUE