Informatica Powercenter grid Difference between Joiner and lookup Difference between router and filter What is mapplet and it's limitations Session Partitioning Scenario based questions and Unix and SQL questions

Question

Accepted Answer

Explaining differences between Informatica Powercenter grid components and concepts

Joiner combines data from two sources based on a common key, while Lookup retrieves data from a reference table based on a matching key
Router sends data to different targets based on specified conditions, while Filter removes rows from a data set based on specified criteria
Mapplet is a reusable object that contains a set of transformations, but has limitations such as not being able to use dynamic lookup cache
Session Partitioning divides a session into smaller parts to improve performance and scalability
Scenario-based questions may involve designing a data integration solution for a specific business case, while Unix and SQL questions may test knowledge of scripting and querying

Accepted Answer

lookup supports<=,>=,=,!= · 2) Joiner has left, right,full,inner join, lookup is left outer join. · 3) One can ...

Informatica Powercenter grid Difference between Joiner and lookup Difference between router and filter What is mapplet and it's limitations Session Partitioning Scenario based questions and Unix and SQL questions

Top Cognizant Associate interview questions & answers

Popular interview questions of Associate

Top HR questions asked in Cognizant Associate