How we will implement Pushdown Optimization and Types in Informatica with better examples
Answer Posted / nsatyabrat7
Push Down Optimisation normally used for performance issue.
to use it u have to buy a separate license along with Informatica. As Sridhar tld there are 3 different kind of Push down optimisation which can be configured in session properties level.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to load rows into fact table in data warehouse
How do you remove duplicate records in informatica? And how many ways are there to do it?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is an Integration service in Informatica?
What are the different clients of powercenter?
Explain load alternative records / rows into multiple targets - informatica
Informatica Checkpoints
differences between service based and product based?
Briefly explain the aggregator transformation?
Mention a few design and development best practices for informatica?
permutations of mapplet
What is difference between a gateway node and worker node?
How can you generate reports in informatica?
Explain your project of banking domian.
Explain the different lookup methods used in informatica?