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

write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5

2 Answers   TCS,

---

Is it possible to update the target table with PK?

1 Answers   TCS,

---

What are batches?

0 Answers  

---

What are the challenges you have faced in your project?

1 Answers   Cognizant, Infosys,

---

Explain the different kinds of facts.

0 Answers  

---

---

Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks

1 Answers   IBM,

---

Explain the pipeline partition with real time example?

0 Answers   Informatica,

---

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

3 Answers  

---

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

Difference between task flow and linear task flow

0 Answers  

---

Explain sessions?

0 Answers  

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

0 Answers  

---