My Oracle Support Banner

List of Target TGT Stage Tables That Are Unsourced in CDA (Doc ID 2420182.1)

Last updated on AUGUST 02, 2018

Applies to:

Oracle Health Sciences Clinical Development Analytics - Version 3.0.0 and later
Information in this document applies to any platform.

Goal

CDA has several columns in CDA data warehouse that are unsourced. "Unsourced" means, CDA does not fetch this data from any of the current sources (CTMS, OC , Inform).
This could be for multiple reasons - one being -- none of the current source applications have this data. TGT tables are among those.

These columns are provided in CDA data warehouse as placeholder in case customers do have any source from which they want to fetch this data.
In case customers want to fetch such unsourced data then they have to develop their custom ETL to load data into staging tables.
CDA does provide ETLs to load data from staging tables to target tables, ( you may see the SILs for TGT tables and these are executed as part of the load plan).

All TGT tables are unsourced and require custom SDE to load these tables. TGT SIL mappings are part CDA installer.
 

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!


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