PowerDesigner és ODI

Séma és táblák kiválasztása

SNP_MODEL Models and their attributes.
SNP_SUB_MODEL Sub-models and their attributes.
SMOD_TYPE Sub-models belong to a model and may reference other
SNP_TABLE Datastores and their attributes.
SNP_COL Columns and their attributes.
SNP_KEY Primary key (PK), Alternate keys (AK) and Indexes.
SNP_KEY_COL PK, AK and Indexes Columns.
SNP_JOIN References or Foreign Keys.
SNP_JOIN_COL Simple Reference Columns mapping.
JOIN_COL references JOIN and COL (twice)
SNP_COND Conditions and Filters defined for a datastore.

Betöltési log:

Reverse Engineering
Reverse engineers the database ...

Reverse engineering tables...
Table SNP_COL
Index COL_FK1
Index COL_FK2
Index IDX_COL_DATE
Key AK_COL
Key AK_COL_GUID
Key PK_COL
Table SNP_COND
Index COND_FK1
Index COND_FK2
Index IDX_COPND_DATE
Key AK_COND
Key AK_COND_GUID
Key PK_COND
Table SNP_JOIN
Index IDX_JOIN_DATE
Index JOIN_FK1
Index JOIN_FK2
Index JOIN_SC_TAB_PK_FK
Key AK_JOIN
Key AK_JOIN_GUID
Key PK_JOIN
Table SNP_JOIN_COL
Index IDX_JOIN_COL_DATE
Index JOIN_COL_FK1
Index JOIN_COL_FK2
Index JOIN_COL_FK3
Key AK_JOIN_COL
Key AK_JOIN_COL_GUID
Key PK_JOIN_COL
Table SNP_KEY
Index IDX_KEY_DATE
Index KEY_FK1
Key AK_KEY
Key AK_KEY_GUID
Key PK_KEY
Table SNP_KEY_COL
Index IDX_KEY_COL_DATE
Index KEY_COL_FK1
Index KEY_COL_FK2
Key AK_KEY_COL_GUID
Key PK_KEY_COL
Table SNP_MODEL
Index GENERIC_MODEL_FK
Index IDX_MODEL_DATE
Index SNP_MODEL_FK1
Index SNP_MODEL_FK2
Index SNP_MODEL_FK3
Index SNP_MODEL_FK4
Index SNP_MODEL_FK5
Index SNP_MODEL_FK6
Key AK_MODEL
Key AK_MODEL_GUID
Key PK_MODEL
Table SNP_SUB_MODEL
Index IDX_SMOD_DATE
Index SUB_MODEL_FK1
Key AK_SMOD
Key AK_SUB_MODEL_GUID
Key PK_SUB_MODEL
Table SNP_TABLE
Index IDX_TABLE_DATE
Index IND_TABLE_RESNAME
Index TABLE_FK1
Index TABLE_SHORTCUT_FK
Index TBL_FMT_TYPE_FK
Key AK_TABLE
Key AK_TABLE_GUID
Key PK_TABLE
9 object(s) have been reverse engineered.

Reverse engineering references...
Reference between tables SNP_COL and SNP_TABLE
Reference between tables SNP_COL and SNP_COL
Reference between tables SNP_COND and SNP_TABLE
Reference between tables SNP_COND and SNP_MODEL
Reference between tables SNP_JOIN and SNP_TABLE
Reference between tables SNP_JOIN and SNP_TABLE
Reference between tables SNP_JOIN and SNP_TABLE
Reference between tables SNP_JOIN_COL and SNP_JOIN
Reference between tables SNP_JOIN_COL and SNP_COL
Reference between tables SNP_JOIN_COL and SNP_COL
Reference between tables SNP_KEY and SNP_TABLE
Reference between tables SNP_KEY_COL and SNP_KEY
Reference between tables SNP_KEY_COL and SNP_COL
Reference between tables SNP_MODEL and SNP_MODEL
Reference between tables SNP_SUB_MODEL and SNP_MODEL
Reference between tables SNP_TABLE and SNP_TABLE
Reference between tables SNP_TABLE and SNP_SUB_MODEL
17 object(s) have been reverse engineered.