Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to create a Change Capture Task in DAC

Question
1
Views
0
Comments

Requirement: We will store Member Details in One schema and Non Member Details in one Schema (table structure is same)

We had created One Mapping and 2 Workflows respect to that mapping with different Source DB Connections

In DAC Created 2 task for 2 workflows. The Tasks are running Fine when we run individually. When I put them in subject area and run full load “Change Capture” task is Created and running for Member DB but not for Non Member DB

As we need to run Incremental load for both the task, For Member It will run Perfect but not for non-Member

Need:

Change Capture Task need to run For Member and Non Member DB, As we need  DAC is not allowing me to create Task with Task Phase = ‘Change Capture’

Please share your comments how to create Change Capture task with another DB