Carry Over Filename As Output Column

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
marothisu
Participant
Posts: 25
Joined: Wed Oct 07, 2009 3:29 pm

Carry Over Filename As Output Column

Post by marothisu »

Hello,

I was wondering if it is at all possible to "detect" a filename from an input stage such as a Complex Flat File Stage? For example, if I am reading in three files: "records2000.csv", "records2001.csv", and "records2002.csv" from a Complex Flat File Stage, I would like one of the output columns to indicate which file the current record came from.

Is this possible? I am aware there is a File Name column in the Sequential File Stage, but what about Complex Flat File?


Thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Complex Flat File stage does not have this functionality.

Indeed I was not aware that this stage can read more than one file at a time.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply