How we will implement Pushdown Optimization and Types in Informatica with better examples
Answer Posted / 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 |
Post New Answer View All Answers
What is decode in static cache?
How do you load alternate records into different tables through mapping flow?
I have a flat file, want to reverse the contents of the flat file
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How to generate or load values in to the target table based on a column value using informatica etl tool.
what is mean by complex business rule ?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is dynamic cache?
how to load dimension table and fact table. plz tell me the steps.
Explain incremental aggregation in informatica
What is the sql query overwrite in source qualifier in informatica
How union transformation is used?
What is the Rank index port in Rank transformation?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Separate from an archive server and a powerhouse?