Answer Posted / rkumar.etl

if you want to process using unix/linux...we can use head
and tail logic to get the records from 21 to 30.

and in informatica we can use rank transformation twice to
get the required results.

What is a rank transform?

1026

---

What is the commit type if you have a transaction control transformation in the mapping?

973

---

What are the different transaction levels available in transaction control transformation?

1122

---

What is decode in informatica?

1074

---

What is a passive transformation?

1039

---

What is source qualifier transformation in informatica?

950

---

What is joiner transformation in informatica?

995

---

What do you mean by filter transformation?

904

---

Parameter and variable differences

2007

---

Differentiate between joiner and lookup transformation?

1049

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2317

---

What is informatica? Why do we need it?

1041

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1112

---

What are the advantages of informatica?

959

---

What is a surrogate key?

1020

---