Answer Posted / raka

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

Explain the use of aggregator cache file?

1317

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1112

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1063

---

What's the layout of parameter file (what does a parameter file contain?)?

2437

---

Enlist the tasks for which source qualifier transformation is used.

1075

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2599

---

What is the way to execute pl/sql script using informatica mapping?

1681

---

Write the different tools in the workflow manager?

1117

---

What is the sql query overwrite in source qualifier in informatica

1142

---

What is resilience time?

1227

---

What is informatica etl tool?

1059

---

Enterprise data warehouse your projects phase by phase explain?

1964

---

What does “tail –f” command do and what is its use as an Informatica admin.

1147

---

explain one complex mapping with logic? sales project?

6733

---

What is the difference between a connected look up and unconnected lookup?

1002

---