Data Type Mapping Set
XML files have been created to store mappings from one set of data types to another. Setting this field to "(Default)" will cause Data Warehouse Designer to automatically select the relevant mapping set; otherwise you can choose one of the standard mapping sets from the drop down list or create a new one.
Once the connection has been set up, you can right mouse click the connection in the middle pane and view the properties for that connection.
Database Link Load - Linked Server
A Database Link Load through a linked server can have a number of source databases:
SQL Server
Oracle
DB2 for Linux, UNIX and Windows (the DB2 RED can build a warehouse in)
Teradata
Sybase
MySQL
DB2/400 (the DB2 that runs on AS/400 machines - quite different to above)
MS Access
Excel
The connection object properties window has the following fields: