User ID and Password
Unused.
DB2 Connections
Database
Database connection types have multiple load table types and locations that influence behavior:
Database link load - from another table in the same DB2 system (includes federation)
Database link load - via CLI from a DB2 table in another system
Data Warehouse
This section describes the connection to the Data Warehouse. Tutorial 1 gives basic instructions for creating a connection. This topic describes in greater detail the connection properties as they apply to the Data Warehouse connection. This connection is used in the drag and drop functionality to create the dimension, stage, fact and aggregate tables. It is also used to create cubes.
TIP: The Data Warehouse connection must exist if you wish to use drag and drop to create dimensions, stage tables, fact tables, aggregates and cubes.
