Search

Database View Reference

Database View Reference

10.4.0
- 10.5.6
- 10.5.4
- 10.5

Back Next

IDPV_CURATED_FOREIGNKEYS

IDPV_CURATED_FOREIGNKEYS

This view exposes the curated foreign key relationship information.

The following table describes the columns in the IDPV_CURATED_FOREIGNKEYS view:

Column	Description
PROFILE_ID*	ID of the profile.
PROFILE_NAME	Name of the profile.
PROFILE_TASK_ID	ID of the profile task.
PROFILE_TASK_NAME	Name of the profile task.
FK_RECORD_NAME	Name of the foreign key data source.
FK_COLUMNS	Foreign key value in the curated data object relationship. If the foreign key value is a composite key, the column stores multiple foreign key values separated by a comma.
PK_RECORD_NAME	Name of the primary key data source.
PK_COLUMNS	Primary key value in the curated data object relationship. If the primary key value is a composite key, the column stores multiple primary key values separated by a comma.
CURATION_STATUS	Status of the curated data object relationship. The column stores the string value Accepted or Rejected.
*Indicates that the column is a key column.

Profiling Warehouse Views

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.