Interested to Buy Any Domain ? << Click Here >> for more details...
When we enable pushdown optimization technique, two options
will be enabled (use view,..). Can anyone tell me how these
two options will work ?
When do we need to go for pushdown optimization technique ?
- 3 Answers
- 17525 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / parikhita prusty
MY dear friend when we used pushdown optimization it
increases the session performanse.
The integration service analyses mapping transformations and
determine which t?r logic to be sent to the target and
source database.
The integration servicetranslates the T/r logic into sql and
sends it into the database for processing.
The pushdown optimization is configured in 3 ways
i) Source side PDO
ii)Target side PDO
iii)Full side PDO(Both source and target side)
If anybody have some doubts u can ask in my mail id
parikhita2000@gmail.com
Regards
Parikhita
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / priyank
Hi,
For Pushdown optimization, we use
1. Temporary View for the below scenarios:
a. When the SQ or look up t/f contain a SQL override.
b. When the look up t/f is used with Filter t/f.
c. When an unconnected look up is used.
2. Temporary Sequence is used for the below scenario:
a. When a Sequence generator t.f is used in the mapping.
When Source side PDO is selected, the IS traverses from
Source side to the Target side till it comes across a
transformation whose logic cannot be pushed to the
database. If the logic for all the transformations can be
pushed to the database, still the target update override
query will be executed on the target database as logic of
transformations are pushed to the database whcih includes
the SQ query.
As per me, the push down optimizations are mainly used for
performance enhancement of the workflows as there are some
logics which can be exected faster on the database compared
to Informatica.
Please let me know all your comments if any on the above.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / manojkumar
Thanks you so much parikhita.
Can you give me the exact two options(use view,..) which
will enabled when we select pod and how these options will
work?
When I select pod on source side, what about target insert
or update query ? will it be pushed to target db? Or only
select query will be pushed to source db ?
and when do we need to go for pushdown optimization
technique ? ofcourse it increses the performance. But at
what situation or circumstances we need to go for pod ?
| Is This Answer Correct ? | 0 Yes | 0 No |
what is galaxy repository?
why do u use shortcuts in informatica.?
How to create Target definition for flat files?
In operator is used in which transformation in informatica 8.6.0
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
why we need informatica
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
HOW TO YOU LOAD TIME DIMENSION
How the informatica server increases the session performance through partitioning the source?
hi all, Can anyone please tell me the relationship between informatica and business objects
In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...
Teradata 
