Answer Posted / satya

If we use Aggregator without using group by option we will
get only one row from source. It is a default charater of
Informatica.

e.g If there are 20 rows in the source table and only
using SQ and followed by Aggregator then target table then
the target table will be populated by the last row coming
from teh source table.

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1039

---

What is persistent lookup cache?

1026

---

what is mean by complex business rule ?

2154

---

What is the function of aggregator transformation?

1078

---

define galaxy repository in informatica

2220

---

What is the difference between STOP and ABORT options in Workflow Monitor?

1253

---

generate date / time dimension in informatica

1119

---

What is an active transformation?

1093

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2716

---

What is resilience time?

1127

---

How to create or import flat file definition in to the warehouse designer?

1067

---

What are roles and groups and benefits of using them?

1053

---

Difference between Target-based loading and constraint-based loading?

992

---

Clarify the aggregator change?

1020

---

Is it possible to revert a global repository to local one and why?

1077

---