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.

Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 Answers  

---

if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 Answers  

---

Explian the Process of deployment groups in informatica

0 Answers   Informatica,

---

Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

6 Answers   iFlex, Morgan Stanley,

---

what is the complex transformation you used in informatica

0 Answers   TCS,

---

---

How would you copy the content of one repository to another repository?

0 Answers  

---

Tell me about informatica architecture.

2 Answers   TCS,

---

What is degenerated dimention table?

7 Answers   Patni,

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

0 Answers   Cap Gemini,

---

How to get EVEN & ODD numbers separately?

8 Answers  

---

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

3 Answers   HP,

---

Explain about Informatica server process that how it works relates to mapping variables?

0 Answers   Informatica,

---