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.

Using the Oracle database it is possible to create a database link to another Oracle database as standard, or to any other database by using Oracles Heterogeneous Services. Tutorial 1 gives basic instructions for creating a connection. This topic describes in greater detail the connection properties. From this type of connection you can do database link loads.

When coming to the Data Warehouse from an OLTP source system, the connection defines the path to get to those source tables. A connection object must be defined for each source system.

 

Database link load - through a database link to another Oracle server: