NORMALIZE AND DENORMALIZE USING TALEND

NORMALIZE: Normalize flat row with items. Split a record having comma separated values for a column into multiple records.

Job:

 

Procedure:

1.       Create metadata for our input delimited file i.e. “normalize.txt”

 

2.       Drag the metadata created into the designer workspace and select tFileInputDelimited component.

3.       Drag tNormalize component onto the Job Designer from Palette and connect it to tFileInputDelimited using rowàmain.

4.       Double click the component tNormalize and click on Sync columns to propagate the metadata of tFileInputDelimited. Now select the column skills in the column to normalize and provide item separator “;”

 

s.

5.       Drag component tLogRow and connect it to tNormalize component using rowà main.

6.       Run the job and check the output in Run console.

Output:

                               

DENORMALIZE: Group multiple records into single record based on a key.

 

Job:

 

Procedure:

1.       Create metadata for our input delimited file i.e. “denormalize.txt”

 

2.       Drag tDenormalize component onto the Job Designer from Palette and connect it to tFileInputDelimited using rowàmain.

3.       Double click the component tDenormalize and click on Sync columns to propagate the metadata of tFileInputDelimited. Now select the column skills in the column to denormalize and provide delimiter 

as “;”

4.       Drag component tLogRow and connect it to tDenormalize component using rowà main.

5.       Run the job and check the output in Run console.

Output: