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;

Explain in detail scd type 2 through mapping.

617

---

Explain lookup transformation in informatica

648

---

What is rank transform?

603

---

Enlist the differences between database and data warehouse.

550

---

How can you define user defied event?

622

---

---

What is a shortcut and copy in Informatica and how two are different with each other?

688

---

Explain pushdown optimization $pushdownconfig parameter - informatica

703

---

What does reusable transformation mean?

676

---

How many ways are there to do 'remove duplicate records in informatica'?

585

---

which one is better performance wise joiner or look up

628

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

679

---

Differentiate between joiner and lookup transformation?

618

---

Explain the different lookup methods used in informatica?

587

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

610

---

what is SDLC way of code development?

1561

---