Last updated on DECEMBER 09, 2015
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
Million Knowledge Articles and hundreds of Community platforms