Answer Posted / raka

SQL:
SELECT id, salary from <table name> where rownum <= 10
ORDER BY salary DESC;

How identifying bottlenecks in various components of informatica and resolving them?

1057

---

How to do unit testing in informatica? How to load data in informatica ?

1050

---

Did u used latest transformations of 8.6.0? for what?

1826

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2062

---

How can we update a record in the target table without using update strategy?

1089

---

What is the advantage of informatica?

1016

---

Enlist the various types of transformations.

955

---

Explain in detail scd type 2 through mapping.

991

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2142

---

What is the cumulative sum and moving sum?

1139

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2256

---

Write the different tools in the workflow manager?

995

---

How can we use batches?

968

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1590

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1219

---