RE: How to get source file name to store in table column
we have a list of system variables present at each jobflow/dataflow level .
Out of the system parameters we use the ”$$SrcFileName” present in the dataflow level parameters list, which will populate the source file name. this parameter can be added to an expression transformation attribute. The same attribute can be mapped into the target attribute.
This would populate the filename present in the extraction properties and load it into the target table column.