Answer Posted / amedela chandra sekhar

write sql query in the source qualifier t/r

sql override

select * from(select dense_rank () over (order by sal desc
nulls last)as rnk,emp.* from emp)where rnk<=10;

What are the tasks that source qualifier perform?

1033

---

what is the Default Source Option For Update Strategy Transformation?

1170

---

How an expression transformation differs from aggregator transformation?

993

---

What is persistent lookup cache?

970

---

What is mapplet in informatica?

983

---

What is complex mapping?

1069

---

How to generate sequence numbers?

1031

---

What is an expression transformation in informatica?

964

---

Which transformation is needed while using the Cobol sources as source definitions?

1128

---

How does the aggregator transformation handle null values?

1087

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2310

---

how to create user defined function (udf) in informatica

1248

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

9981

---

What is InformaticaPowerCenter?

1077

---

what is the size of your data warehousing?

2044

---