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.

What is the function of look up transformation?

1054

---

What are the different ways to implement parallel processing in informatica?

1340

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5683

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1842

---

What is the benefit of partitioning a session?

1102

---

How to create the source and target database connections in server manager?

1034

---

what is diff b/t sorter t/r and agg have the option sorter property...

2129

---

What are session parameters ? How do you set them?

1773

---

Define filter transformation?

1031

---

How to create Target definition for flat files?

1157

---

Can you use flat files in Mapplets.

2609

---

What is parallel processing in informatica?

1619

---

Please let me know how to make Data masking in informatica..

1663

---

What is a repository? And how to add it in an informatica client?

1082

---

How can we delete duplicate rows from flat files?

1162

---