Function STG_DIMENSION_LOADER.STG_DATALOADER Not Updating Null Attribute Value of V_LEVEL1_PROD_DESC
(Doc ID 2609772.1)
Last updated on FEBRUARY 23, 2023
Applies to:
Oracle Financial Services Data Foundation - Version 8.0.0 and laterOracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Oracle Financial Services Profitability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Data Foundation (OFSDF)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Goal
Function stg_dimension_loader.stg_dataLoader is not updating the attribute value in the table DIM_PRODUCTS_ATTR for the null value. If the value is other than null then it updates the value.
The merge statement like below:
merge into DIM_PRODUCTS_ATTR target_table
using (
select
bb.PRODUCT_ID id_column,5558 attribute_id
,aa.V_LEVEL1_PROD_DESC attr_val
from stg_product_master aa
, DIM_PRODUCTS_B bb
where
fic_mis_date = to_date('20181231','RRRRMMDD')
and aa.V_LEVEL1_PROD_DESC is not null
and aa.v_prod_code = bb.PRODUCT_CODE
...
In which the condition as "and aa.V_LEVEL1_PROD_DESC is not null"
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 |