Currently Processed Flat File Name

Effective with PowerCenter 8.5 there is an option called Add Currently Processed Flat File Name Port.
If this flat file source option is selected, the file name port will be added in the ports of the source.
This is particularly helpful when loading the files in Indirect method and we need to pass the currently processed file name to the target.

To add the CurrentlyProcessedFileName port:

•     Open the flat file source definition in the Source Analyzer.
•     Click the Properties tab.
•     Select Add Currently Processed Flat File Name Port .
•     The Designer adds the CurrentlyProcessedFileName port as the last column on the Columns tab.
•     The CurrentlyProcessedFileName port is a string port with default precision of 256 characters.
•     Click the Columns tab to see your changes.
•     You may change the precision of the CurrentlyProcessedFileName port if you wish.

  To remove the CurrentlyProcessedFileName port, click the Properties tab and clear the Add Currently Processed Flat File Name Port check box.

Note .While processing xml files you can connect this port to only one target because in xml source each hierachy work as an active source.


Hope this helps.