Answer Posted / nag

Hi,

I think this scenario will help u.
Source - SQ Trans(2 Instances)-target(2 different targets)

In one of the Instances of SQ Trans write this Query:

select distinct <field name>......from <table name>;

Note:- It fetches only unique records.

In another Source instance write the following query:

select * from <table name> where rowid not in (select max
(rowid) from <table name> group by <field name>);
ex:- select * from emp where rowid not in (select max
(rowid) from emp group by ename);

Note:- It fetches only duplicate records.

then pass the fields to the targets(u should take different
targets).

I hope this will work.

Thanks and Regards,

Nag

How do you remove duplicate records in informatica? And how many ways are there to do it?

713

---

What is the surrogate key?

633

---

What is powercenter on grid?

691

---

Describe an informatica powercenter?

607

---

What is a sorter transformation?

657

---

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1554

---

Write the unconnected lookup syntax?

654

---

How to do unit testing in informatica?

718

---

When do you use sql override in a lookup transformation?

584

---

Partition, what happens if the specified key range is shorter and longer

2029

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

805

---

Briefly define reusable transformation?

624

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1529

---

What is informatica worklet?

610

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

637

---