Answer / venkateshmalneni

by using only filter t/r we cannot delete duplicate records.
but by using combination of aggrigator and filter t/r we can achive it


in aggrigator t/r create a new o/p port to count_rec with expression count(key column)
connect all the ports to filter and write a condition count_rec=1.now connect ports to the target

Answer / mahaboob basha

connot delete the duplicate records while using filter t/r

Answer / devendar pd

if we use group by key columns in aggrigator then automatically duplicates will be removed, no need to create o/p port again.

I think we can't remove duplicates only by using filter

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

3 Answers   Accenture, CSC,

---

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

---

How do you change parameter when you move it from development to production.

1 Answers  

---

What is depict expression change?

0 Answers  

---

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,

---

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

---

whats the option in informatica 7 version is outdated in informatica 8 version onwards.

1 Answers   iGate,

---

how can u approach u r client

2 Answers   CTS,

---

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.

3 Answers   Wipro,

---

Types of error logs in Informatica?

2 Answers  

---

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,

---

What is the meaning of decode in informatica?

0 Answers  

---