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 some properties of sessions.

1053

---

Explain lookup transformation source types in informatica

1076

---

Explain in detail about scd type 1 through mapping.

1404

---

On which transformations you created partitions in your project?

1319

---

What is the use of target designer?

1021

---

What are the different components of powercenter?

1026

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

1072

---

Please let me know how to make encryption and decryption with example?

1884

---

What is aggregate cache in aggregator transformation?

1122

---

How are the sources and targets definitions imported in informatica designer?

1087

---

Explain your project of banking domian.

1639

---

How do we call shell scripts from informatica?

1083

---

What is the reusable transformation?

1031

---

How many ways a relational source definition can be updated and what are they?

992

---

What are mapplets?

1249

---