How we will implement Pushdown Optimization and Types in Informatica with better examples
Answers were Sorted based on User's Feedback
Answer / sridhar,informatica developer
normally pushdown optimization is used for eliminating
bottlenecks from session and to increase the performance of
your session.
here t he integration service pushing the business logic to
the target or source or both.
pushdown optimization can do in 3 ways
1)source side
2)target side
3)full
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / sridhar,informatica developer
normally pushdown optimization is used for eliminating
bottlenecks from session and to increase the performance of
your session.
here t he integration service pushing the business logic to
the target or source or both.
pushdown optimization can do in 3 ways
1)source side
2)target side
3)full
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / abhinaw prakash
Just to add on the above points.We cannot decide which
transofrmation logic to send to the Database.The
integrations service decides which login to send to the
database to optimize the process.although we can see the
sql logic in the Pushdown priview and the messages and
warning attached to it.
Is This Answer Correct ? | 0 Yes | 0 No |
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?
What is rank index in rank transformation?
waht type of interface is used for testing the data in informatica
What is substr in informatica?
How can u stop a batch?
Explain sessions. Explain how batches are used to combine executions?
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
1 lac of flat fles in source how to load target at a time?
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
what is target load plan
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?