Talend tDenormalize

We can use this Talend tDenormalize to denormalize or flatten the columns. To demonstrate the Talend tDenormalize, let me use this text file. As you can see, each employee has multiple Sales values, and our job is to denormalize that Sales column.

Source Text File

Talend tDenormalize Example

Before we started creating a tDenormalize job, we created the denormalize Source text file metadata. We use these DenormalizedSource metadata as the normalized source.

Let me use that file delimited metadata as the Talend Denormalize component source.

Configure the Source text file in the workflow

Next, drag and drop the tDenormalize into the job window.

Add Talend tDenormalize to Workflow to Normalize the Data

As you see from the below tDenormalize component tab, it has a window to add the required column. It is the column that you want to denormalize, and the delimiter that you wish to use. Please use the + button to add denormalized columns.

Please click on the Talend Denormalization Edit Schema button to check the input & output columns.

Click the Talend tDenormalize Edit Schema to check the Normalize Columns

We added Sales as the denormalized column and the semicolon as the delimiter.

Add Columns in Talend tDenormalize to Workflow to Normalize the Data

Next, we used the tLogRow to display the result of the denormalized data. For this, add the tLogRow and within the Components tab of i, select the Table (print values in cells of Table) option. Let us run the Talend tDenormalize job and see the result.

Run the Talend tDenormalize Job to Workflow to Normalize the Data

Let us save this tDenormalize output in the text file that includes the header and the columns separated by ” ‘ “. Next, run the Talend tDenormalize job.

Configure the Talend tDenormalize Output to Workflow to Normalize the Data

Next, open the NormData text file to show you the result.

Result Text