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

How You Pull the records on daily basis into your ETL Server.

2 Answers   TCS,

---

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,

---

if the column name in sql override is diff from the column name in source qualifier,what is the impact?

5 Answers   TCS,

---

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

---

WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?

1 Answers   Wipro,

---

how to read data from website into informatica? plsss send answers ASAP thanks in advance.

1 Answers   DELL,

---

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,

---

Tell me about MD5 functions in informatica

0 Answers  

---

How to enter same record twice in the target table,explain?

7 Answers  

---

What is an expression transformation in informatica?

0 Answers  

---

Design time, run time. If you don't create parameter what will happen

0 Answers  

---

How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,

---