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
Why do you use Mapping Parameter and mapping variable?
What are the new features of informatica 9.x developer?
What is expression transformation?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is Index Caches size?
Define the various join types of joiner transformation?
Explain load alternative records / rows into multiple targets - informatica
How can informatica be used for an organization?
What is decode in informatica?
Briefly define reusable transformation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is difference between a gateway node and worker node?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What are the tasks that can be performed using sq?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?