OFSAA T2T Join Construction Best Practice
Last updated on SEPTEMBER 04, 2017
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.
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