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 ?
Answer Posted / 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 |
Post New Answer View All Answers
What is resilience time?
Explain sessions and how many types of sessions are there?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
In warehouses how many schemas are there?
How to generate sequence numbers?
Where are the source flat files kept before running the session?
Explain pushdown optimization $pushdownconfig parameter - informatica
What does “tail –f” command do and what is its use as an Informatica admin.
design of staging area?
What does reusable transformation mean?
What is the function of look up transformation?
Explain lookup transformation source types in informatica
How big was your fact table
How are indexes created after completing the load process?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?