Informatica Interview Question and Answers

21. What are various types of Aggregation?
 
    Various types of aggregation are
  • SUM
  • AVG
  • vCOUNT
  • MAX
  • MIN
  • FIRST
  • LAST
  • MEDIAN
  • PERCENTILE
  • STDDEV
  • VARIANCE
 
Your Name Your Email-ID
Your Answer
22. What are Aggregator Transformation?
  Aggregator transformation is an Active and Connected transformation. This transformation is useful to perform calculations such as averages and sums (mainly to perform calculations on multiple rows or groups).
 
Your Name Your Email-ID
Your Answer
23. What are Expression transformation?
  Expression transformation is a Passive and Connected transformation. This can be used to calculate values in a single row before writing to the target.
 
Your Name Your Email-ID
Your Answer
24. What are Filter transformation?
  Filter transformation is an Active and Connected transformation. This can be used to filter rows in a mapping that do not meet the condition.
 
Your Name Your Email-ID
Your Answer
25. What are Joiner transformation?
  Joiner Transformation is an Active and Connected transformation. This can be used to join two sources coming from two different locations or from same location.
 
Your Name Your Email-ID
Your Answer