Admin of Source tables used in a datastage project

[admin]

We a trying to come to terms with administration of the source table extracts via odbc

A common request to our Administrator is: A table on the source system is either being dropped on having columns dropped/modified Our administrator is required to identify any impact to the datastage project.

To do this in a efficent manner the administrator needs to be able to scan/lookup all odbc objects both generated and user defined to determine is there is an y impact.

How have other organizations been able to make this a simple and complete process.

Many thanks



CAUTION: This correspondence is confidential and intended for the named recipient(s) only. If you are not the named recipient and receive this correspondence in error, you must not copy, distribute or take any action in reliance on it and you should delete it from your system and notify the sender immediately. Thank you.

Unless otherwise stated, any views or opinions expressed are solely those of the author and do not represent those of Vodafone New Zealand Limited.

Vodafone New Zealand Limited
21 Pitt Street, Private Bag 92161, Auckland, 1020, New Zealand Telephone + 64 9 357 5100 Facsimile + 64 9 377 0962