🎴 Flashcard Mode
MicroStrategy and Informatica Enterprise Data Tools
Card1 / 20
Mastered0
Review0
QuestionClick to flip
In an Aggregator transformation, the aggregation expression can contain_______
AnswerClick to flip back
A
Aggregate functions
B
Conditional clauses
C
Nested aggregate functions
D
Non-aggregate functions
💡 Explanation:
The Aggregator transformation in Informatica allows aggregation expressions to contain aggregate functions (SUM, COUNT, etc.), conditional clauses (CASE/DECODE), nested aggregate functions (AVG(SUM(x))), and even non-aggregate functions for conditional logic. This flexibility enables complex aggregation logic within a single transformation, supporting sophisticated data summarization requirements.