How to add Custom PLP ,SDE & SIL interfaces to ODI load Plans in OBIA 11.1.1.7.1

Dt: 15 March 2014

Well its easy.

Of the many things you would like to do to get this done.Here are a few.

Make  the flex fields on the custom tables in Models to  point to fact group --> X_CUSTOM_FG. This lets ODI know all your custom fact tables.
Create foreign keys in ODI to the dimensions attributed in your custom facts.
This helps in understanding dependencies.

Just like you would add Informatica sessions to the DAC task lists.
Add the ODI scenarios into the BI Apps Load Plan provided Out of The Box.
You need to add your scenarios to the X_CUSTOM Facts, X_CUSTOM Dims in the LOAD PLAN DEV components.
There are seperate classifications for SDE,SIL & PLP.

Unfortunately once you go to the PLP section here you will not find the custom groups available.
No worries just create your own custom Load plans here within the parallel steps.

Once you have added your scenarios those will reflect in the new load plan done using custom fact group(X_CUSTOM_FG).

For PLP you have to add your newly created load plans into the  LOAD PLAN SYSTEM components.
This is a small piece of wiring which has to  be done.This was left unanswered in the documentation.

For that matter ODI with OBIA is like a new game on the blocks.Steps & rules provided for most of the things but then some hidden secrets left for you to explore.


Seems like a blockbuster so far.