Answer Posted / srikanth

select (select marks from sub where subject='maths') maths,
(select marks from sub where subject='science') science,
(select marks from sub where subject='social') social from
sub group by 1;

What is the session task and command task?

1052

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1131

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1688

---

How do we call shell scripts from informatica?

1107

---

What is the difference between writing a joiner query in ANSI style and THETA style?

2374

---

Differences between connected and unconnected lookup?

1211

---

What is a surrogate key?

1078

---

Enterprise data warehouse your projects phase by phase explain?

1917

---

What is data caches/ index caches?

1097

---

What is the use of an aggregator cache file?

1199

---

What is the advantage of informatica?

1065

---

explain one complex mapping with logic? sales project?

6663

---

How we can create indexes after completing the load process?

1156

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2030

---

What do you mean by channel change?

1039

---