What is an aggregator transformation? it is active why cant
it be passive explain?
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
What are the steps involved in the migration from older version to newer version of Informatica Server?
What are the measure objects?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Explain sessions and how many types of sessions are there?
Briefly describe lookup transformation?
How to go to the older version for a mapping?
how tokens will generate?
What is Data Caches size?
What is aggregate cache in aggregator transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
if we have a delimiters at unwanted places in a flat file how can we over come those.
Enterprise data warehouse your projects phase by phase explain?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
How to do unit testing in informatica?
What are the new features of informatica 9.x in developer level?