write a query following source
region sales
1 1000
2 2000
i want the output ?please give solution
1 2
1000 2000
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/
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Differentiate between joiner and lookup transformation?
How big was your fact table
difference between repository database and repository service?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is fact table? Explain the different kinds of facts.
What does role playing dimension mean?
Define update strategy?
How might you approve all mappings in the archive all the while?
How many numbers of sessions can one group in batches?
Define filter transformation?
What are the different types of transformation available in informatica.
What are data-driven sessions?
How do we call shell scripts from informatica?
What is meant by lookup transformation? Explain the types of lookup transformation?
Which is the t/r that builts only single cache memory?