Pages

Friday, July 18, 2014

DAC 11g Evaluate Parameters Feature

Issue: Sometimes before triggering the Execution plan, we always worrying about what parameters DAC  is going to pass to the Informatica.(Especially in BI Apps environment).

Solution: Use "DAC11g Evaluate parameters" feature available at Execution plan tab.

Here is the little more explanation to make use of it.

Step 1: Login to DAC and click  "Execution" button and select "Execution plan" tab then select your execution plan.

Execution plan selection

Step 2: Go to "Ordered Tasks" child tab and right click on any tasks. Select "Evaluate Parameters".

Right click on the tasks

Step 3: It will ask you to proceed. Click on "Yes".

Evaluate Parameters input window


Step 4: It will take sometime to get the parameters name and corresponding values.


So here is the output of the parameters name and their values.

Note: 

a) You will get to know whether the Task will go for Incremental or Full Load.
b) Initial Extract date and Last Extract Dates.
c) Database Connection values

 All these details are enough for us to stand confidently.

CHEERS :)

No comments:

Post a Comment