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

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1931

---

Differentiate between source qualifier and filter transformation?

1508

---

What is a pre-defined event and user-defined event?

972

---

Define mapplet?

961

---

How to update a particular record in target with out running whole workflow?

1533

---

How can we store previous session logs?

989

---

how we can load rejected record's at run time?(not through bad files)

2314

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7266

---

What does command task mean?

1062

---

What is an aggregator transformation?

1030

---

-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?

5682

---

What is a standalone command task?

1134

---

How to delete duplicate row using informatica?

982

---

Difference between Target-based loading and constraint-based loading?

944

---

What is a joiner transformation and why it is an active one?

998

---