Target Tables
|
Description
|
W_XACT_SOURCE_TMP
|
These tables hold the temporary results as a part of conforming
rocess.It is used as a part of ETL process to conform the data to fit the DS
and FS tables.
|
W_XACT_SOURCE_D_PE
|
Tables used to support the soft delete feature. The table
includes all the primary key columns (integration ID column) from the source
system. When a delete event happens, the full extract from the source
compares the data previously extracted in the primary extract table to
determine if a physical deletion was done in the Siebel application. The soft
delete feature is disabled by default. Therefore, the primary extract tables
are not populated until you enable the soft delete feature. Note that there
are two types of delete tables: _DEL and _PE.
|
W_SALES_INVOICE_LINE_FS
|
Staging tables used to hold the metrics being analyzed by
dimensions that have not been through the final ETL transformations.
|
W_PROD_CAT_DHS
|
Staging tables for storing the hierarchy structures of
dimensions that have not been through the final extract-transform-load (ETL)
transformations.
|
W_POSITION_DH
|
Tables that store the dimension's hierarchical structure.
|
A blog where you can explore everything about Datawarehouse, OBIEE, Informatica, Power BI, QlikView, Hadoop, Oracle SQL-PLSQL, Cognos and much more....
Monday 13 August 2012
Different types of Target tables in OBIEE?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment