Can the DT fn_popDimAccount Function be Used to Load Data Into DIM_ACCOUNT Table in 8.x?
Last updated on JANUARY 11, 2018
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 (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Business Intelligence Enterprise Edition (OBIEE)
Oracle Financial Services Asset Liability Management Analytics (ALMBI)
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA/PFTBI) previously known as Oracle Financial Services Profitability Analytics
Currently using the DT fn_popDimAccount which invokes the OOTB Package /function : STG_POP_DIM_ACCOUNT.populateDimAccount, to populate the DIM_ACCOUNT table.
This function however does not consider the LOAD RUN ID concept and hence if the base table contains multiple LOADS for the same date (with the same set of ACCOUNTS), it populates multiple records in DIM_ACCOUNT.
How this should be handled ?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms