Page 1 of 1
Find the file name details used in a stage
Posted: Sat Jun 11, 2011 6:04 am
by 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 .
Posted: Sat Jun 11, 2011 6:38 am
by kduke
The easiest way is to parameterize the name. Then get the runtime value for the parameter.
Re: Find the file name details used in a stage
Posted: Sat Jun 11, 2011 7:05 am
by 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.
Re: Find the file name details used in a stage
Posted: Mon Jun 13, 2011 6:26 am
by 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
Posted: Mon Jun 13, 2011 8:48 am
by 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.