Capturing Source and Target Table Names
Posted: Tue Mar 11, 2008 4:07 pm
Hello,
I have a requirement to capture the names of the source and target tables/files used in the parallel job.
For Example: If I have 3 sources A,B and C, I need to assign A|B|C (concatination of Source Table Names A,B and C) and store it in a parameter and later assign this value of the parameter to a column in a sequential file.Similar logic for the Target Table Names/Files. Values should be dynamically assigned for different jobs.
Any suggestions how Can I implement this is datastage?Any inputs will be greatly appreciated.
Thanks
I have a requirement to capture the names of the source and target tables/files used in the parallel job.
For Example: If I have 3 sources A,B and C, I need to assign A|B|C (concatination of Source Table Names A,B and C) and store it in a parameter and later assign this value of the parameter to a column in a sequential file.Similar logic for the Target Table Names/Files. Values should be dynamically assigned for different jobs.
Any suggestions how Can I implement this is datastage?Any inputs will be greatly appreciated.
Thanks