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 / 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 |
Post New Answer View All Answers
What are the differences between a connected lookup and unconnected lookup?
What are the advantages of using informatica as an etl tool over teradata?
What is incremental aggregation?
Difference between Data and Index Caches?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Which files are created during the session rums by informatics server?
How do we call shell scripts from informatica?
In how many ways we can create ports?
What is the meaning of up gradation of repository?
How many ways a relational source definition can be updated and what are they?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain target update override in informatica
What is deployment group?
What differs when we choose the sorted input for aggregator transformation?