Internal tables are used primarily by ETL mappings for data transformation and for controlling ETL runs. These tables are not queried by end users.
Name | Purpose | Location |
---|---|---|
W_DUAL_G |
Used to generate records for the Day dimension. |
Data warehouse |
W_COSTLST_G |
Stores cost lists. |
Data warehouse |
W_DOMAIN_MEMBER_G |
Staging table for populating incremental changes into W_DOMAIN_MEMBER_G and W_DOMAIN_MEMBER_G_TL. |
Data warehouse |
W_DOMAIN_MEMBER_G_TL |
Stores translated values for each installed language corresponding to the domain member codes in W_DOMAIN_MEMBER_G_TL. |
Data warehouse |
W_DOMAIN_MEMBER_GS |
Stores all the domain members and value for each installed language. |
Data warehouse |
W_DOMAIN_MEMBER_MAP_G |
Used at ETL run time to resolve at target domain code base on the value of a source domain code. |
Data warehouse |
W_DOMAIN_MEMBER_MAP_NUM_G |
Used at ETL run time to resolve a target domain code based on the comparison of a numeric value within the source numeric range. |
Data warehouse |
W_EXCH_RATE_G |
Stores exchange rates. |
Data warehouse |
W_LANGUAGES_G |
Stores the language translations supported in the data warehouse and is used during ETL to help generate missing translation records from the base language called pseudo-translation. |
Data warehouse |
W_LOCALIZED_STRING_G |
Data warehouse |
|
W_LOV_EXCPT_G |
Stores the list of values for the list of values types in which the ETL process finds exceptions. |
Data warehouse |
W_UOM_CONVERSION_G |
Stores a list of From and To UOM codes and their conversion rates. |
Data warehouse |