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).
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.
Select the (pencil) Edit symbol to edit Data Loads type or to quickly access versions of load history for that entity.
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)
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.
Select the Sample Data icon to access a quick view of Fields and Field Values.
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.
