Create one Logical Schema per Physical Schema.

Create one Logical Schema per Physical Schema that stores the same type of data.

Create one Logical Schema per Data Server.

Create one Logical Schema per Context.

In the ODI Interface palette, choose the more convenient graphic objects to link the involved servers.

You need not draw directly in the data flow all the details about how the different servers involved are connected. ODI automatically designs the flow and how servers are connected.

You need not draw directly in the data flow all the details about how the different servers involved are connected. The code will be the black box generated directly by ODI.

You must draw directly in the data flow all the details about how the different servers involved are connected, and also specify with variables the passwords for connecting to the data contained in the servers.

The intermediate integration table prefixed with I$ is required to determine which records must be inserted.

If Flow Control is not necessary, an I$ table is not created .

The intermediate integration table prefixed with I$ is created because the flow control is mandatory when doing an initial load.

Neither the LKM nor the IKM create intermediate tables. Most of their work is performed in the ODI Agent memory.