Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to follwoing table
amount year quarter
254556 2003 first
546332 2003 second
129034 2003 third
490223 2003 fourth
165768 2004 first
265443 2004 second
510412 2004 third
435690 2004 fourth
i want the output
year q1_amount q2_amount q3_amount q4_amount
2003 254556 546332 129034 490223
2004 165768 265443 510412 435690
- 2 Answers
- 5534 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / praveen hattikal
Select YEAR,SUM(q1_amt)q1_amt,SUM(q2_amt)q2_amt,SUM(q3_amt)
q3_amt,SUM(q4_amt)q4_amt from (
select YEAR,
Decode (QUARTER,'first',amount,0) as q1_amt,
Decode (QUARTER,'second',amount,0) as q2_amt,
Decode (QUARTER,'third',amount,0) as q3_amt,
Decode (QUARTER,'fourt',amount,0) as q4_amt
from table_name) group by YEAR
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How can we update a record in the target table without using update strategy?
What is workflow? What are the components of the workflow manager?
Explain the aggregator transformation?
what are 3 tech challenges/ common issues you face?
What is mapplet in informatica?
Can we create a node as a gateway node and the same node can be assigned to a grid?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is a surrogate key?
What are the tasks that source qualifier perform?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is the difference between source qualifier transformations source filter to filter transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is a rank transform?
What is the function of aggregator transformation?
what is the difference between informatica6.1 and infomatica7.1
