Answer Posted / ankit kansal

Hi All,
As Question says Write a sequel query..


select sum(1),sum(2) from (
select case when region=1 then salary else 0 end as 1,
case when region=2 then salary else 0 end as 2
from table_name )test;

http://deepinopensource.blogspot.com/

Differentiate between joiner and lookup transformation?

1159

---

How big was your fact table

1861

---

difference between repository database and repository service?

1224

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1305

---

What is fact table? Explain the different kinds of facts.

1125

---

What does role playing dimension mean?

1088

---

Define update strategy?

1316

---

How might you approve all mappings in the archive all the while?

1082

---

How many numbers of sessions can one group in batches?

1101

---

Define filter transformation?

1148

---

What are the different types of transformation available in informatica.

1145

---

What are data-driven sessions?

1261

---

How do we call shell scripts from informatica?

1191

---

What is meant by lookup transformation? Explain the types of lookup transformation?

1020

---

Which is the t/r that builts only single cache memory?

1238

---