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
- 17354 Views
- IBM, I also Faced
- E-Mail Answers
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 the complex transformation you used in informatica
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is expression transformation?
What is target designer and target load order?
what is degenerated dimension?
On which transformations you created partitions in your project?
What are the different versions of informatica?
Differences between connected and unconnected lookup?
Whats there in global repository
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What are the different clients of powercenter?
Explain what are the different versions of informatica?
In warehouses how many schemas are there?
What is a mapplet/worklet in informatica?
Explain the informatica workflow?
