Database Schema to hold ODI temporary objects

This might be quite trivial for most ODI developers but key for ODI newbies.

 

It is a best practice to use a separate schema for holding ODI temporary objects (such as C$_ or I$ tables).

This schema is named “WORK SCHEMA” in ODI and it can be setup in the “Physical Schema” within the Topology tab. For instance, “ODI_TEMP” is a quite intuitive name for this purpose:

cap10

 

For more information on this topic, please refer to: http://odiexperts.com/why-creating-a-separate-schema-for-temporary-tables-in-odi/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s