Answer Posted / ram mohan reddy

we can do this process by 2 ways ....
1)by dynamic lookup option in lookup(new lookup row) we can
load duplicate rows in one target table and unique rows in
one target table
do to this we need to have router transformation (add to
group ports one is for unique(new lookup row=1) and other is
for duplicate(new lookup row =2))after the lookup trans.
2)we can perform this by aggregator transformation using
coutnt(*) >1 for duplicate rows .here also we need to use
router transformion.

How to configure mapping in informatica?

1169

---

What does “tail –f” command do and what is its use as an Informatica admin.

1096

---

How to generate sequence numbers without using the sequence generator transformation?

1201

---

How to open an older version of an object in the workspace?

1198

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6166

---

What is informatica worklet?

1057

---

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

1086

---

Do you find any difficulty while working with flat files as source and target?

1092

---

What do you understand by a term domain?

1122

---

What is the sequence generator transformation in informatica?

1178

---

What are multi-group transformations?

1084

---

What is the need for an etl tool?

1063

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1072

---

expain about the tune parameters?

2408

---

What is the difference between Active and Passive transformation?

1148

---