DAC Metadata

1) All Containers          -  W_ETL_APP

2) All User accounts     -  W_ETL_USER

3) All Subject areas      -  W_ETL_SA

   a) All task related to subject area     - W_ETL_SA_STEP

   b) All tables related to subject area   - W_ETL_SA_TABLE

4) All Tables               -  W_ETL_TABLE

   a) All columns for a table                 -  W_ETL_TABLE_COL

   b) All indexes associated for table     -  W_ETL_INDEX

   c) All source/Target for a task           -  W_ETL_STEP_TBL

5) All Indexes             -  W_ETL_INDEX

   a) Columns associates to a index    - W_ETL_INDEX_COL

6) All Task groups       - W_ETL_STEP

   a) Associates child tasks - W_ETL_GROUP_STEP

7) All Tasks                -  W_ETL_STEP

   a) All Source/Target tables associates to tasks - W_ETL_STEP_TBL

   b) Task associated to a subject areas             -  W_ETL_SA_STEP

8) All Configuration Tags - W_ETL_TAG

   a) All subject areas associated to this CT     -    W_ETL_TAG_SA

   b) All tasks associated to this CT                -    W_ETL_TAG_STEP

9) All source system parameters   -   W_ETL_PARAM

10) All source system folders       -   W_ETL_PARAM

11) Container specific SQL           -   W_ETL_APP_TMPLT 

1) DAC system properties    -  W_ETL_SYSPROP

2) Informatica servers         -  W_ETL_SERVER

3) All Physical data sources  - W_ETL_DBCONN

  a) Tables associated to Physical data souce and its "Refresh dates" information                       -    W_ETL_REFRESH_DT

4) E-mail recipients           -  W_ETL_EMAIL

5) Working patches           - W_ETL_PATCH

(Patches created information will be stored here. 

   a) Patch content            -  W_ETL_PATCH_DATA

   b) Child patches            -  W_ETL_PATCH_CHILD

6) Applied patches           -   W_ETL_APATCH

   a) Applied patch content           -  W_ETL_APTC_DATA

   b) Applied child patches            -  W_ETL_APTC_CHLD

   c) Deleted objects by this patch - W_ETL_APTC_DEL 

1) All execution plans     -    W_ETL_DEFN

    a) Subject areas associated to the EP    -  W_ETL_DEFN_SA

    b) Tables belongs to the EP                 -  W_ETL_DEFN_TBL

    c) All tasks involved in the EP              -   W_ETL_DEFN_STEP 

    d) Connectivity parameters for this EP   - W_ETL_DEFN_PRM

2) Current Run / Run History -   W_ETL_DEFN_RUN

    a) Task belongs to the EP                  -   W_ETL_RUN_STEP

    b) Details for a tasks in EP                -  W_ETL_RUN_SDTL

    c) Audit trial (No.of time EP restarted) -  W_ETL_RUN_AUDIT

    d) Phase summary                            - W_ETL_RUN_STEP

    e) Run type summary                       -   W_ETL_RUN_SDTL

3) EP Schedule information           -  W_ETL_SCHEDULE