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


Please Help Members By Posting Answers For Below Questions

Why do you use Mapping Parameter and mapping variable?

1506


What are the new features of informatica 9.x developer?

760


What is expression transformation?

876


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

1671


What is Index Caches size?

884


Define the various join types of joiner transformation?

807


Explain load alternative records / rows into multiple targets - informatica

938


How can informatica be used for an organization?

929


What is decode in informatica?

851


Briefly define reusable transformation?

869


Name at least 5 different types of transformations used in mapping design and state the use of each.?

928


What is difference between a gateway node and worker node?

892


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6499


What are the tasks that can be performed using sq?

861


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1950