Generating functional keys in the output flow - 7.3

Identification

EnrichVersion
Cloud
7.3
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
EnrichPlatform
Talend Studio
task
Data Governance > Third-party systems > Data Quality components > Identification components
Data Quality and Preparation > Third-party systems > Data Quality components > Identification components
Design and Development > Third-party systems > Data Quality components > Identification components

For more technologies supported by Talend, see Talend components.

This three-component scenario describes a basic Job that generates a functional key for each of the data records using one algorithm on one of the input columns, PostalCode.

This functional key can be used in different ways to narrow down the results of data filtering or data matching, for example. So the tGenKey component can be used with so many other data quality and data integration components to form different useful use cases. For an example of one use case of tGenKey, see Comparing columns and grouping in the output flow duplicate records that have the same functional key.

In this scenario, the input data flow has four columns: Firstname, Lastname, DOB (date of birth), and PostalCode. This data has problems such as duplication, first or last names spelled differently or wrongly, different information for the same customer, etc. This scenario generates a functional key for each data record using an algorithm that concatenates the first two characters of the postal code.