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
- 18089 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
Explain how many types of dimensions are available in informatica?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What are pre and post-session shell commands?
What are the different types of olap? Give an example?
What is workflow monitor?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How to extract the informatica rejected data?
How to create Target definition for flat files?
How do you load first and last records into target table?
What is data transformation manager process?
What is Session and Batches?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
In informatica workflow manager, how many repositories can be created?
