What is an aggregator transformation? it is active why cant
it be passive explain?
- 3 Answers
- 17288 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mike
Well an aggregator transformation is an active connected
transformation which is used to convert detailed values in
to summary values by using aggregator functions like sum,
avg, max, min etc...if a mapping contains aggregator
transformation the informatica server executes the
expression each for every group of record. The aggregator
transformation is based on four parameters
1)groupby ports
2)group expression
3)stored inputs
4)incremental aggregation
As every one knows an aggregator transformation is active
because it executes less out put than no of inputs(detailed
values in to summarized values)...
By the definition an active transformation is the
transformation in which the no of outputs will be less than
inputs...
by the definition an passive transformation is the
transformation in which the no of outputs equals to the no
of inputs...
corect me if i was wrong....
| Is This Answer Correct ? | 13 Yes | 1 No |
Answer / rajan raorane
1)Agregator T/R is used to perform summary calcluation
2) It is Active bcoz the output of this T/R is not equal to
input
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / suneelkumar.dasari
C in active T/R the total no.of input records wil be changed(i.e the total input records wont come),but in passive t/r the total no of input records are not changed,and we can add some extra columns.But in Active also we can add columns.
| Is This Answer Correct ? | 2 Yes | 4 No |
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
Can we update the data in flat file using update strategy?
What is limitations of truncate and load option
Enlist the advantages of informatica.
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
What are the designer tools for creating tranformations?
How do you remove duplicate records in informatica? And how many ways are there to do it?
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
What is the difference between informatics 7x and 8x and what is latest version?
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.
What is powercenter on grid?
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
Teradata 
