How to Pull the Column CN_SRP_QUOTA_ASSIGNS_ALL.TARGET into the OIC Analytics Datamart? (Doc ID 2212802.1)

Last updated on DECEMBER 09, 2016

Applies to:

Oracle Incentive Compensation Analytics for Oracle Data Integrator - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

You want to capture the value of CN_SRP_QUOTA_ASSIGNS_ALL.TARGET into CN_F_QUOTA table.  As the table "cn_s_quota_fact_source" is used as stage table in ODI mapping, you are asking if you can add a column "TARGET"?

 

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