Answer / kish

Hi Krishna,

i think you r wrong...he is asking abt flat file...
by using LOOKUP we can eliminate duplicates...
You can eliminate duplicates and can capture that duplicates
using
dynamic lookup cache. look up the target table if New lookup
row=0 then it is unchanged (duplicate
record) SEND TO ONE TARGET

Answer / srinivas

we can do by using rank transformation also
select rank as 1 top or bottom what ever the ur requirement
and select the group by port for the duplicate column

Answer / sanjay

here i m taking the example of employee table

first use the sorter to get the distinct value....

then use the agg trns, create the output port and use the
count function on employee_id to get the total no. of rows
like.. count(employee_id) and group by employee_id.

create filter trns.. write a condition where output>1... map
it with the target...

Answer / krishna

The source qualifier Trns has select distinc option from thr we can eliminate duplicates

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 Answers   Accenture,

---

How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,

---

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

---

can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,

---

what is the difference between copy object import objects using repositery manager which one is best

1 Answers   TCS,

---

What is confirmed dimension with scenario

1 Answers   HCL,

---

can you use flat file for repository?why?

2 Answers   TCS,

---

Why we require dwh in particular projects?

1 Answers   Amdocs,

---

What are parallel querys and query hints?

1 Answers  

---

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,

---

What is domain in terms of informatica?

0 Answers  

---

What is a repository manager?

0 Answers  

---