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.
Step 2: Go to "Ordered Tasks" child tab and right click on any tasks. Select "Evaluate Parameters".
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 :)
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.
Step 3: It will ask you to proceed. Click on "Yes".
Step 4: It will take sometime to get the parameters name and corresponding 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