Friday, June 13, 2014

Where we can find Customised Reverse engineering Metadata in Repository.

ODI Interview Questions and Answers:

We can find Work Repository SNP_REV_* all tables for Customised reverse engineering metadata.

SNP_REV_TABLE: reverse engineered tables
SNP_REV_COL: Columns of a Datastore
SNP_REV_KEY: Keys or Index to reverse engineer
SNP_REV_KEY_COL: Columns of a Key or Index to reverse
SNP_REV_JOIN: Foreign Keys (Joins/Relations) to reverse
SNP_REV_JOIN_COL: the Foreign Key columns
SNP_REV_COND: Conditions (check constraints)
SNP_REV_FOR_TABLE: Tables to be reverse engineered
Note: this Table is used only in Standard Reverse Engineering, it is not used in Customized Reverse Engineering with a KM
SNP_REV_SUB_MODEL: Sub Model of the Model to reverse engineer


No comments:

Post a Comment