Finding field in Datastage repository
Posted: Fri Jul 13, 2007 12:24 am
Hi,
We are in process of calculating effort estimates of rework in our development due to target datamodel changes.
Changing one field in target model has cascading impact on other jobs due to dependency.There is almost 300+ jobs. Manual process for this would be very time consuming.
So We want to create a report of following information using DS job:
1. to list all DS jobs where a particular target field is used.
2. to find derivation(transformation rule) from the transformer for that target field.
Could anyone of you give any idea or hint on same?
how to achieve this.
thanks in advance
We are in process of calculating effort estimates of rework in our development due to target datamodel changes.
Changing one field in target model has cascading impact on other jobs due to dependency.There is almost 300+ jobs. Manual process for this would be very time consuming.
So We want to create a report of following information using DS job:
1. to list all DS jobs where a particular target field is used.
2. to find derivation(transformation rule) from the transformer for that target field.
Could anyone of you give any idea or hint on same?
how to achieve this.
thanks in advance