Question About Use of STG_BANDS_MASTER and DIM_BANDS Tables in OFSAA 8.0.5 Model
Last updated on DECEMBER 11, 2017
Applies to:Oracle Financial Services Data Foundation - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Data Foundation (FSDF)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Question 1: The table STG_BANDS_MASTER, which was previously used for feeding DIM_BANDS dimension and existed in the 7.3.5 version model, no longer exists in 8.0.5 version.
Has the table been removed in 8.0.5? If yes, why and what is the suggested procedure for DIM_BANDS loading?
Question 2: Would like to load DIM_BANDS from the external dictionary.
In order to stay aligned with OFSAA DIM management principles, should STG_BANDS_(B, _HIE, _TL, _ATTR )_INTF tables be created (as they are not existing in the out-of-the-box model), or there is some other recommended method to load DIM_BANDS?
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