PowerCenter : List SQL Overrides Create a list of SQL Overrides used in various transformations and sessions Description:
During development, many of the transformations are overridden with customized queries and this can cause issues during any dependency or impact analysis
In many instances, you would want to know the SQL overrides written in a mapping Source Qualifier transformation or Lookup SQL override or Pre-SQL & Post-SQL etc. Attached is a
Java executable that will provide all the SQL overrides in the workflow (QuerySQLOverrides.zip)
