My Oracle Support Banner

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 later
Information 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)


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).


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.