Thursday, January 3, 2013

What are the steps to follow while starting an Execution Plan in Oracle DAC?



Note: This is not a complete end to end steps to use Oracle DAC. These steps can be followed when Most of the ETL development is done, all tasks are included in DAC, Subject Areas created, Execution Plan is built. Development Cycle and Stage - Bug fix / Enhancements / UAT.

We need to check for configurations in DAC and in Informatica before starting the load.

DAC Configurations

           Setup Tab

  1.  Check the Informatica server connections, is it pointing to the server that has the latest code/ required fixes? If not, then change the configurations and Test connection.
  2. Check the Source DB and Target DB connections, are they pointing to the required DBs?  If not, then change the configurations and Test connection. 
  3. Also check the table space for creating indexes.
         Design Tab
  1. Date parameters must be checked, if you are doing a full load then check on the Initial extract date, Snapshot dates etc. and set the required date.
  2. Assemble Subject area if needed. Did u change anything at the task level and did not assemble the SA?
         Execution tab
  1. Regenerate the parameters and rebuild the Execution Plan if needed
  2. Are you doing a full load? Then reset the sources. Right click on the EP and select the option to reset sources.
  3. Do not start the load yet, we need to do some checks on Informatica

Informatica Configuration
  1. Check the connections for source and target db. Ask yourself these questions -Do the connection names match with the ones in DAC? and are they pointing to the same db that DAC is pointing to? If any of the answers is a No then enter the correct details
Execution plan kick off
Now we are ready for starting the Execution plan, go ahead and start it