Internal tables in OBIA are used to assist the ETL. We use internal tables in OBIA mainly to store some default values for the mappings and for controlling the ETL runs.
Note:These tables are not run by the user. We cannot set the value for these Internal tables. And also it cannot be managed directly by the DAC.
Example:
Note:These tables are not run by the user. We cannot set the value for these Internal tables. And also it cannot be managed directly by the DAC.
Example:
Tables
|
Description
|
W_PARAM_G
|
Stores parameters for ETL runs.
|
W_DUAL_G
|
Used to generate records for the Day dimension.
|
W_ETL_RUN_S
|
Stores the details about ETL run.
|
W_EXCH_RATE_G
|
Stores exchange rates.
|
No comments:
Post a Comment