Multiple choice technology

Only one aggregate function can be nested within an aggregate function

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Informatica allows nesting of aggregate functions (like SUM(MAX(salary))) but does NOT allow one aggregate function directly inside another aggregate function - you must use group by ports appropriately. The restriction is on direct nesting, not on using multiple aggregate functions in the same expression.

Keep practicing — related questions