Find the file name details used in a stage

[devnhi]

Is there any way to find out the file name details that is used in a sequential file stage . I am able to get the row count , but want to find out the name of the file that is used in that particular stage.

I would really appreciate any information regarding .

[kduke]

The easiest way is to parameterize the name. Then get the runtime value for the parameter.

[samyamkrishna]

You can see the file name in the logs if it is used as a parameter.
Open the job and see if it is hard coded.

[ds_dwh]

in seq file create one additional column in column tab,
then follow the below path
properties--->options-->filenamecolumn

in filename columngive your additional column name

[kduke]

There is a job in EtlStats that loads all the properties in PX stages into a table called ETL_PROPERTY or something like that. If you can find the job and make it work then you can get these values into a table you can query. Different stages have different properties. You have to figure out the property name to retrieve the value associated with it.