Tip - List SQL Overrides

11 years 6 months ago #7656 by Or Pelach
PowerCenter : List SQL Overrides
Create a list of SQL Overrides used in various transformations and sessions
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)

Attachment QuerySQLOverrides.zip not found


Please התחברות to join the conversation.

Moderators: Laromme Barr
Time to create page: 0.278 seconds