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/

complex mapping ur project u r invlve can u explain and give real time example give me ?

2235

---

What is data movement mode in Informatica and difference between them?

1057

---

What is the session task and command task?

991

---

Enlist the differences between database and data warehouse.

1033

---

what is the Default Source Option For Update Strategy Transformation?

1166

---

Separate from a database, an information bazaar, and an information stockroom?

1011

---

How do you set a varible in incremental aggregation

1826

---

What all join we can perform in LOOKUP transformation?

913

---

What is a node in Informatica?

1003

---

What is informatica etl tool?

941

---

What are the popular informatica products?

958

---

State the differences between sql override and lookup override?

1113

---

What are the tuning techniques you applied during your last project

1965

---

What can we do to improve the performance of informatica aggregator transformation?

1042

---

What are the informatica performance improvement tips

1017

---