Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,


What is a joiner transformation and why it is an active one?

0 Answers  


What is the use of source qualifier?

0 Answers  


What the difference is between a database, a data warehouse and a data mart?

0 Answers  


What is a configuration management?

1 Answers  






if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,


how to duplicates from expression transformation without using sorter before that

1 Answers  


What is staging area?

11 Answers  


What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,


In which scenario did u used Mapping variable?

1 Answers   Cognizant,


While importing the relational source definition from the database, what are the metadata of source that will be imported?

0 Answers   Informatica,


why dimenstion tables are denormalized in nature ?

3 Answers  


Categories