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....

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

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.

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

---

If I have a index defined on target table and if set it to bulk load will it work ?

4 Answers   IBM,

---

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

4 Answers   Cap Gemini, IBM,

---

My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,

---

what is procedure to use mapping variable in source qualifier transformation? with example

1 Answers   IBM,

---

Is there any model difference between ODS and DWH

2 Answers   Zensar,

---

in which situations do u go for starflake schema ?

6 Answers   TCS,

---

Explain the tuning lookup transformation - informatica

0 Answers   Informatica,

---

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

---

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

---

What is batch and describe about types of batches?

2 Answers  

---

What is update override?

1 Answers   Accenture,

---