Answer / hari

create mapping like

source -- sorter -- expression -- filter -- target.

here sorter is used to send data by ascending order data
this is not mandatory.

Expression is need to create variable port which will count
the rows which are comming in.

Filter having condition like if count value >=51 and count
value <= 100.

Answer / venkateshmalneni

Generate sequence by using sequence generator or by using expression t/r
connect the output to the filter t/r in filter write the condition as sno>=51 and sno=100
connect it to the target

src--->sq---> expression--->filter--->target

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

5 Answers   Puma,

---

What are active transformations? Name them.

1 Answers  

---

How to do Integration testing in Informatica?

5 Answers   Intelligroup,

---

what is workflow varible

1 Answers   HP,

---

what is fact and what types of fact tables is there

4 Answers   Cap Gemini,

---

What is a filter transformation and why it is an active one?

0 Answers  

---

Using Expression transformation how to remove duplicate records from a relational source?

4 Answers  

---

How to delete duplicate records in a flat file source?

2 Answers  

---

what is the function of 'F10' informatica ?

4 Answers   IBM,

---

what is shared lookup&persistent lookup?

4 Answers   Accenture, Cap Gemini,

---

SO many times i saw "$PM parser error " .what is meant by PM?

1 Answers  

---

What is the role of informatica in project ?Like i showed financial projects?

1 Answers   Amdocs,

---