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

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

2346

---

How many dimensions are there in informatica?

1132

---

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

1105

---

Whats there in global repository

1736

---

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1962

---

explan ur project architecture?

2126

---

How might one distinguish in the case of mapping is right or not without associating session?

1194

---

Scheduling properties,whats the default (sequential)

2007

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

2249

---

What is update strategy transform?

1158

---

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

2550

---

How to improve the performance of a session using sorter transformation?

1186

---

What are the tuning techniques you applied during your last project

2072

---

What are active transformations.

1702

---

What are the limitations of joiner transformation?

1176

---