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

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1049

---

What is deployment group?

1129

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2063

---

How to update source definition?

1030

---

Can we get 1st record through Informatica(without sequence number).

1406

---

How can a transformation be made reusable?

1077

---

How does the aggregator transformation handle null values?

1085

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1805

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1894

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1050

---

What is xml source qualifier transformation in informatica?

1175

---

What you know about transaction control transformation?

935

---

What is the command used to run a batch?

994

---

can anyone explain me about retail domain project in informatica?

7890

---

What is the function of look up transformation?

1054

---