How we will implement Pushdown Optimization and Types in Informatica with better examples
Answer Posted / 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 |
Post New Answer View All Answers
How do you migrate data from one environment to another?
How do you load only null records into target?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
what is mean by complex business rule ?
Differences between connected and unconnected lookup?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Can we override a native sql query within informatica?
Explain the shared cache and re-cache?
How identifying bottlenecks in various components of informatica and resolving them?
waht type of interface is used for testing the data in informatica
What is olap (on-line analytical processing?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How many ways are there to do 'remove duplicate records in informatica'?
Mention few advantages of router transformation over filter transformation.
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?