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 JULY 29, 2024

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)

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


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