Answer Posted / julius caeser

Hi
There are 2 ways to do this and both of them are efficient.
Method 1: Sorter -Filter.
Send all the data to a sorter and , sort by all feilds that
u want to remove duplicacy from . note that in the
preoperties tab, select Unique .
This will select and send forward only Unique Data .

Method 2; Use an Aggregator
Use AGG Transformation and group by the keys /feilds that u
want to remove duplicacy from.

How might you approve all mappings in the archive all the while?

1012

---

How to extract sap data using informatica?

1039

---

What are the different components of powercenter?

1042

---

What is Data Caches size?

1086

---

What is the benefit of session partitioning?

1111

---

How many numbers of sessions can one group in batches?

1060

---

How we can create indexes after completing the load process?

1152

---

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

1064

---

What are the different types of repositories created using informatica?

1116

---

Explain how to import oracle sequence into informatica?

1004

---

Reusable transformation and shortcut differences

1838

---

How do you handle two sessions in Informatica

1145

---

What is update strategy transform?

1096

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1121

---

Can we create two repositories on same database instance in oracle?

1083

---