Can fn_STGDimDataLoader Load Dimension Data from STG_PRODUCT_MASTER to DIM_PRODUCTS_XXX tables Including _HIER?
(Doc ID 2618663.1)
Last updated on MARCH 02, 2023
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and laterInformation in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Goal
How to load the data from STG_PRODUCT_MASTER to DIM_PRODUCTS_B/TL/ATTR, including HIER?
DIM_PRODUCTS_HIER table cannot be loaded into using the master table approach. How can hierarchy information be loaded to HIER table?
OOB stage dimension loader (i.e. fn_STGDimDataLoader) for example, loads the data from STG_PRODUCT_MASTER into DIM_PRODUCTS_B, DIM_PRODUCTS_TL and DIM_PRODUCTS_ATTR table only (not including DIM_PRODUCTS_HIER).
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |