Interested to Buy Any Domain ? << Click Here >> for more details...
What is an aggregator transformation? it is active why cant
it be passive explain?
- 3 Answers
- 18049 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to configure mapping in informatica?
What are the reusable transformations?
How to open an older version of an object in the workspace?
How many ways are there to do 'remove duplicate records in informatica'?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What all join we can perform in LOOKUP transformation?
What is the meaning of decode in informatica?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Explain what are the different types of transformation available in informatica.
What is informatica worklet?
What are pre and post-session shell commands?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is the cumulative sum and moving sum?
Explain sql transformation in script mode examples in informatica
