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/

Enlist the various types of transformations.

1062

---

Explain transaction control transformation in informatica

1275

---

Repository user profiles

1768

---

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

1105

---

During the running session, output files are created by informatica server. Enlist few of them.

985

---

without table how to come first record only in oracle?

2260

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1037

---

How to go to the older version for a mapping?

1102

---

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

1132

---

What do you mean by channel change?

1051

---

Mention few power centre client applications with their basic purpose?

956

---

how to load rows into fact table in data warehouse

1194

---

What is flashback table ? Advance thanks

1944

---

What are the different types of olap? Give an example?

1057

---

What are the types of caches in lookup?

1052

---