My Oracle Support Banner

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

Last updated on FEBRUARY 27, 2019

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

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.