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
- 18213 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 |
What is joiner change?
what is size of u r database?
What is joiner transformation in informatica?
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?
Where is the cache stored in informatica?
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
What is the Difference between DSS & OLTP?
What is the need of an ETL tool?
What do think which one is the better joiner or look up?
Does Facttable Normalized or Denormalized?
Teradata 
