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

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,

---

Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers   Informatica,

---

Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 Answers  

---

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com

0 Answers  

---

Is it possible to define a single node as a Gateway node as well as worker node?

0 Answers  

---

How to improve the session performance in informatica?

3 Answers   Accenture,

---

In any project how many mappings they will use(minimum)?

1 Answers  

---

What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 Answers  

---

How do you load alternate records into different tables through mapping flow?

0 Answers  

---

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,

---

What is staging area?

11 Answers  

---

What is sequence generator transformation in informatica?

0 Answers  

---