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.

Insert else update option in which situation we will use

4 Answers   HCL,

---

How can u stop a batch?

2 Answers  

---

What are batches?

0 Answers  

---

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

---

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

0 Answers   CTS,

---

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers  

---

what is row level and column level indicator?

1 Answers   TCS,

---

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,

---

i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

3 Answers   Satyam,

---

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 are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,

---

Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,

---