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 .
Find the file name details used in a stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
Re: Find the file name details used in a stage
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.
Open the job and see if it is hard coded.
Re: Find the file name details used in a stage
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
then follow the below path
properties--->options-->filenamecolumn
in filename columngive your additional column name
ANJI
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.
Mamu Kim