HCM Data Loader aka (also known as ) HDL is the next generation Data Loading Tool used in Fusion Applications.
Mostly used in all new implementation starting July 2015 this tool has tremendously advanced features compared to its predecessor FBL (File Based Loader).
In this article we would try to understand what HDL is and also a brief understanding of key concepts associated with the same.
So without much ado let’s begin….
Bulk loading of HCM data from any source
Data-migration or incremental updates
Flexible, pipe-delimited file format
Comprehensive bulk loading capabilities
Automated and user managed loading
Stage Table Maintenance
As with all delivered HCM Extracts, it is recommended that you make a copy of the HCM Data Loader Data Set Summary extract and alter the output to your requirements.
Navigate to the Manage Extract Definitions task available from the Data Exchange work area.
Query the HCM Data Loader Data Set Summary extract.
You click the copy icon to copy the seeded extract, supply your name for the copied extract.
Once your copy is successfully created you can retrieve it by searching for it by name. Click on the name in the Search Results to make your required changes
Last but not the least 
Thanks a lot for all your time .. Have a Nice Day!!!!!!!!!!!!!
Apps2Fusion Articles 