הצטרפו לקבוצות שלנו לקבלת עדכונים מרוכזים פעם בשבוע:

ווטסאפ:
http://wa.dwh.co.il
טלגרם:
http://telegram.dwh.co.il

Tip - List SQL Overrides

More
11 years 11 months ago #7656 by Or Pelach
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)

Attachment QuerySQLOverrides.zip not found

Attachments:

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

Moderators: Laromme Barr
Time to create page: 0.354 seconds