Answer Posted / reddevilzzzz

@ Shalu
Your answer is almost correct. The question says, you have
to use Aggregator transformation.
Select all the rows from SQ.
Pass them to aggregator transformation. Group By on all
ports.
Create a Output port in Aggregator(lets call it TOTAL) and
give expression as COUNT(Col1).
Create a Router transformation, with 2 groups. In one group
(lets call it UNIQUE), put condition as TOTAL = 1.
In another group (lets call it DUPLICATES), put condition
as TOTAL>=2.
Pass the output from UNIQUE group to table where we want
unique rows.
Pass the output from DUPLICATE group to table where we want
duplicate rows.

P.S - tried and tested :):)

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1036

---

Write the different tools in the workflow manager?

995

---

Explain the features of connected and unconnected lookup.

877

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

2237

---

What do you mean by channel change?

967

---

What is lookup transformation?

1005

---

What are the mapping parameters and mapping variables?

1090

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2210

---

While migrating the data from one environment to another environment how would you manage the connections?

1048

---

What is complex mapping?

1069

---

What is source qualifier transformation in informatica?

950

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

2046

---

What is target load order?

1190

---

What are active and passive transformations?

1023

---

What are pre and post-session shell commands?

1239

---