Cognos Data Manager Builds

Cognos Data Manager Builds are used for loading data from a source table in to a destination table. It also provide way to transform, filter and modify the source data. Following are the main activities performed by a simple Build: 

1. Connect to Source (Excel, Flat File, database servers...).
2. Bring data from source.
3. Transformed the source data.
4. Connect to destination.
5. Load the clean and filtered data in destination (Excel, Flat File, database servers...).

Here is a step by step guide to create a simple Build for Pulling Data from a text file to a database table.

Your valuable comments will be highly appreciated.