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 two types of processes that informatica runs the session?

2 Answers  

---

differences between service based and product based?

0 Answers   Satyam,

---

if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,

---

What are batches?

0 Answers  

---

Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc

10 Answers   Cap Gemini, IBM,

---

---

what are the unix commands to start the wrk flow ?

4 Answers   Accenture, TCS,

---

Can you use one mapping to populate two tables in different schemas

2 Answers  

---

Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,

---

how to create user defined function (udf) in informatica

0 Answers   Informatica,

---

What is IQD file?

1 Answers  

---

source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

4 Answers   Polaris,

---

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

1 Answers   Qwest,

---