HDL: Extract Failed Lines

From version 20B there in an extra feature been added in the import load data section which is quite useful.

You can now generate the load file only for the failed rows from the import and load screen. You just need to enable this option

Setup and Maintenance > HCM Data Loader > Configure HCM Data Loader

It will enable the 'Extract Failed Lines' option on the Import and Load screen

Just to note that, it works quickly if number of failed line are less but it will take time in case of large volume of failed data.

Talend: Import/Export Items

Export: You can export multiple items from the project onto a directory or as an archive zipped file

1.       In the Repository tree view, select the items you want to export, you can have multiple selections as well

2.1 You can either go with the root directory or Archive file method. Root directory will create the files in the selected folder along with the parent tree structure

Export Dependencies check box exports the routine dependencies along with Jobs you are exporting (Ex: Related File Excel mappings, DB connection etc.)

2.1.1 It created the Project Name and the all the related job files.

2.2 Archive file option will create a ZIP file at the destination

      Export Dependencies check box exports the routine dependencies along with Jobs you are exporting

2.2.1 Zip file created

Import:

1    1.  Right click on the folder or Job design and select ‘Import items’

2.1. The Root directory option will create the structure the way it was exported. You can select individual items as well.

Overwrite existing items check box overwrites the existing items with those having the same names to be imported.

2.1.1 Result will be as like below

2.2 Archive file option will also give you the same result

Talend: tAggregateRow

tAggregateRow palette can be used to get the aggregate value of any column or to get column based on the unique key

Talend: tReplace

Use this palette to replace any column value with a new value

Talend: tSortRow

Use this for sorting the output