Internal Tables in OBIA

Internal Tables in OBIA

Internal tables in OBIA are used to assist the ETL-Extract-Transform-Load. We use internal tables in OBIA mainly to store some default values for the mappings and for controlling the ETL runs. 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.

For 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