ETL Step 7: TARGET
In the TARGET step, the system loads data to the target tables. It obtains the primary key generated in the KEYLOOKUP step, inserts data from the *_XFRN tables to the target tables, updates the target tables according to the data from the *_XFRU and *_XFRU2 tables, and marks the records as deleted through setting MD_ACTIVESTATUSIND to N and updating MD_DELETEDATE as sysdate.
If late arriving data in the previous batch arrives, the system updates MD_BATCH_ID in the *_ XREF tables with the current batch ID.
*_XFRN, *_XFRD, *_XFRU, *_XFRU2, and *_KEY_LOOKUP tables are input in this step while DIM_*, FACT_*, or BRIDGE_* tables are output.
The following table lists the key staging tables.
|
Table Name |
Table Description |
|---|---|
|
DIM_<TARGET_ENTITY_NAME> |
Target dimension tables that include data for reporting. |
| FACT_<TARGET_ENTITY_NAME> | Target fact tables that include data for reporting. |
| BRIDGE_<TARGET_ENTITY_NAME> | Target bridge tables that include data for reporting of many-to-many relationships. |
