OFSAA T2T Join Construction Best Practice
(Doc ID 2087049.1)
Last updated on MAY 07, 2021
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure - OFSAAI
Oracle Financial Services Analytical Applications (OFSAA)
Table to Table (T2T) Data Mapping
What is considered OFSAA best practice in terms of building joins within T2T to key dimensions?
1. Use inner join and build a reporting construct to review the T2T logs and failure tables
2. Use outer join and a nvl() expression in the mapping to assign an agreed "missing" value where the right side value is not found
Note: Both of the above practices are present in OFSAA out of the box applications.
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