write a query following source
region sales
1 1000
2 2000
i want the output ?please give solution
1 2
1000 2000
Answer Posted / ravi
select * from table_name pivot(sum(sales) for region in(1,2));
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a standalone command task?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Differences between connected and unconnected lookup?
What is meant by active and passive transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What are the different clients of powercenter?
what is SDLC way of code development?
What is target load order?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is dynamic cache?
What is the use of target designer?
What is the fact table?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What all join we can perform in LOOKUP transformation?
Explian the Process of deployment groups in informatica