Is The Join For Cashflow Type Code In T2Ts Moving Cashflow Data From Stg To Fct Tables Correct?
(Doc ID 2612700.1)
Last updated on MAY 26, 2020
Applies to:Oracle Financial Services Liquidity Risk Management - Version 8.0.0 and later
Information in this document applies to any platform.
The T2Ts moving data from Stage Account Cash Flow to Fact Account Cash Flows (i.e.) LRM_FCT_ACCT_CASH_FLOWS_OPEN_MAT_TB_POP & LRM_FCT_ACCT_CASH_FLOWS_TB_POP has the below join between STG_ACCOUNT_CASH_FLOWS.V_FINANCIAL_ELEMENT_CODE and DIM_CASH_FLOW_TYPE.V_CASH_FLOW_TYPE_CODE.
'' INNER JOIN DIM_CASH_FLOW_TYPE
ON STG_ACCOUNT_CASH_FLOWS.V_FINANCIAL_ELEMENT_CODE = DIM_CASH_FLOW_TYPE.V_CASH_FLOW_TYPE_CODE
AND DIM_CASH_FLOW_TYPE.F_LATEST_RECORD_INDICATOR = 'Y'
AND DIM_CASH_FLOW_TYPE.V_CASH_FLOW_TYPE_CODE = 'P' ''
If the above join is correct or it should be a join between STG_ACCOUNT_CASH_FLOWS.V_CASH_FLOW_TYPE_CODE and DIM_CASH_FLOW_TYPE.V_CASH_FLOW_TYPE_CODE?
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