Answer Posted / abhishek

U can achive this by using row_number function in source
qualifer example

select col1,col2,salary,emp_id from (select
col,col2,salary,emp_id , row_number() over (partition by
salary order by emp_id )as rec_seq from table)
Where
rec_seq=3

or by rank t/r in mapping

how to create user defined function (udf) in informatica

1240

---

Briefly define reusable transformation?

1074

---

Differentiate between router and filter transformation?

951

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1078

---

How can we store previous session logs?

988

---

What are connected or unconnected transformations?

1048

---

What is exclusive and normal mode for repository services?

1061

---

explan ur project architecture?

2004

---

 Informatica Checkpoints

3267

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2120

---

Write the advantages of partitioning a session?

1200

---

Explain the informatica workflow?

998

---

How you prepared reports for OLAP?

1545

---

What is session task and command task?

1174

---

what is mean by complex business rule ?

2108

---