Tuesday, June 9, 2009

DAC custom execution plan steps

1. Create custom logical and physical folders :
Tools > seed data > task folders

2.Register the new folders : eg - Custom_mappings
Design > source system folders

3. Modify existing DAC tasks to use the custom mappings and workflows

4. Synchronize Task(s )Right click on DAC task and select synchronize. This will add the source and target tables to the task. make sure the DAC task name and informatica task name are the same.

5. Assemble the Subject Area

6. Generate execution plan(EP) parameters . EP parameters include the Infa repository folders related to the container that the EP belongs to . This could be the missing step.Execution > select EP> select Parameters sub-tab > verify/update the folder names > Generate

7. Build the EP

8. Run the EP

-A