OFSAA T2T Join Construction Best Practice

(Doc ID 2087049.1)

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

Goal

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.

Solution

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