User ID and Password
Not used, leave blank.
Oracle Connections
Database
Database connection types have multiple load table types and locations that influence behavior:
Database link load - from a table in the current Oracle database server (includes Oracle gateways and Oracle heterogeneous services)
Database link load - through a database link to another Oracle server
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.
