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

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2068

---

Define mapplet?

1016

---

What is the commit type if you have a transaction control transformation in the mapping?

1033

---

What are the new features of informatica 9.x developer?

970

---

How to use pmcmd utility command?

1038

---

What is sorter transformation?

1050

---

What are the features of complex mapping?

1161

---

What do you mean by filter transformation?

953

---

What is the difference between a connected look up and unconnected lookup?

969

---

How to generate sequence numbers using expression transformation?

1094

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1105

---

What are active transformations.

1659

---

What is confirmed fact in dataware housing?

6974

---

What is the difference between writing a joiner query in ANSI style and THETA style?

2381

---

Which is the t/r that builts only single cache memory?

1190

---