Skip to main content

Source and 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 tabs list fields and identifies primary and foreign keys

initials PK or FK display next to primary and foreign key fields in entity tabs

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

Expand and collapse

Click on the icon expand(expand) icon or icon collapse(collapse) icon to expand or collapse the tab.

 

icon collapse displays on entity tab

Select the icon edit(edit) icon to edit Data Loads type or to quickly access versions of load history for that entity. Data load options include: All data loads, Sample data, Ugly Records, Bad Records, Statistics, and Specific Loads.

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

Select edit icon to choose data load type and optional load date field

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

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

Source information icon, hover over to reveal entity's source

Source information displays when source icon is hovered over

Lineage information for prepare targets

Qlik Catalog 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: 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 the property is enabled.

Field-level lineage for prepare targets can be accessed in the discover module on the fields grid: Select the icon view detailsView Details icon, select lineage tab, expand the icon caret lineage (caret) icon in parent lineage section to display lineage information details Source Name, Entity Name, and Rule which describes the transform flow and which transform controls were used.

Field lineage in discover displays prepare controllers used in dataflow

Lineage tab in discover displays prepare dataflow components

Select the icon sample data (Sample Data) icon to access a quick view of fields and field values.

Sample data

Select sample data icon to display sample data for the entity

Select the fifth icon (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 and profile distribution

Select icons to view profile data and profile distribution