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
Write the different tools in the workflow manager?
What are the types of lookup transformation?
What does command task mean?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is mapplet in informatica?
Briefly define a session task?
Explain the etl program with few examples.
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
How can we remove the duplicates from flat file source?
How to load data in informatica ?
How can we store previous session logs?
What is Index Caches size?
How identifying bottlenecks in various components of informatica and resolving them?
What is session task and command task?
Differentiate between source qualifier and filter transformation?