Saturday, 8 September 2012

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

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

ShareThis