Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Load Plan (ODI)

Load Plan is a feature introduced in ODI to manage the execution of data integration tasks.

It allows you to define the rules about which task are the predecessor task of the other tasks or which tasks can be executed in parallel.

You define the task sequence in a tree like structure.

The Load Plan feature, in one way, is similar to the ODI package which also allows you to define the sequential orders of interface scenarios that are executed within a package.

The major difference are

  • Variable management : Load Plan can inherit variable value from hierarchy; Package refresh the variable
  • Error Handling: Whether you want to rollback the whole unit of work or not
  • Restartability: You can restart the load plan step; you can restart the whole package scenario, the step with the package, or a task within a setp scenario.
  • Branching Logic: ODI can support CASE statement; Package can use EVALUATE step




2 Responses to “Load Plan (ODI)”

  1. […] Load Plan and Load Plan Generator was designed for addressing this requirement. […]

  2. How do you rigorously test a load plan?

Leave a Reply

Please log in using one of these methods to post your comment:

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 )

Connecting to %s