Skip to main content

Source/Target entity features

Source entity contents

Each Entity contains a list of Fields in the Entity, and if applicable, identification of a Primary Key (PK) or Foreign Key (FK).

Entity contents

Entity Contents

For more information about identifying primary and foreign keys shared between related entities see Import relationships and keys

Expand and collapse

Click on the plus or minus symbol to Expand and Collapse the tab.

Description: Description: Screen Shot 8

Description: Description: Screen Shot 9

Select the (pencil) Edit symbol to edit Data Loads type or to quickly access versions of load history for that entity.

Note: Note there is an option to Include Load Date with an editable field name.

Click on the trashcan icon to delete either the source or target entity from dataflow.

The round i icon displays source lineage when hovered over. (ex., 'TestFile') is the source parent object for the entity 'Testr’ in example below)

Data source lineage

Data Source Lineage

Lineage information for prepare targets

Qlik Data Catalyst generates and persists field-level lineage information when enabled through core_env property: enable_prepare_lineage

Lineage information is updated on every Validate and Execute operation of a valid prepare job.

Note that prepare jobs with packages Custom and CDC will not have lineage generated for them.

A second property (enable.prepare.copy.metadata) will copy metadata from parent field to child field (this property only comes into play if prepare lineage is enabled).

Metadata (tags, business description, technical description, business name, blog) is copied from parent to child objects on every Validate and Execute when enabled.

Field-level lineage for prepare targets is accessed in the Discover module on the Fields Grid: Drill into Field Details, select Lineage Tab, expand the field name in Parent Lineage. The lineage information details Source Name, Entity Name, and Rule which describes the transform flow and which transform controls were used.

Field Lineage

Field Lineage

Select the Sample Data icon to access a quick view of Fields and Field Values.

Sample data

Sample Data Icon

Select Profile Data for views into individual field values that include: Minimum Values, Maximum Values, Number of Nulls, Percentage of Nulls, Total Count, Delivery ID, Cardinality, Last Updated Timestamp. Select the view icon to drill in further on fields for Profile and Profile Distribution.

Profile data

Profile Data Icon