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 ? | 8 Yes | 0 No |
Post New Answer View All Answers
what is the size of your data warehousing?
Enlist the advantages of informatica.
How to configure mapping in informatica?
Did u used latest transformations of 8.6.0? for what?
What are the main features of Oracle 8i with context to datawarehouse?
Differences between connected and unconnected lookup?
How to load the data from a flat file into the target where the source flat file name changes daily?
tell me the rules and responsblites in our project(my project is development)
What is meant by incremental aggregation?
What is sq transformation?
Explain the scenario which compels informatica server to reject files?
What is substr in informatica?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How we can create indexes after completing the loan process?
How can you define user defied event?