Interested to Buy Any Domain ? << Click Here >> for more details...
write sql query following table
amount year quarter
1000 2003 first
2000 2003 second
3000 2003 third
4000 2003 fourth
5000 2004 first
6000 2004 second
7000 2004 third
8000 2004 fourth
i want the output
year q1_amount q2_amount q3_amount q4_amount
2003 1000 2000 3000 4000
2004 5000 6000 7000 8000
can anybady help me to achieve the aboue result by using informatica.
thanks in advance.
- 5 Answers
- 7711 Views
- I also Faced
- E-Mail Answers
Answer Posted / hari
select * from (select year,
max(amount,quarter='first') q1_amount,
max(amount,quarter='second') q3_amount,
max(amount,quarter='third') q4_amount,
max(amount,quarter='fourth') q4_amount
from table_name group by year );
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the different transaction levels available in transaction control transformation?
What is a filter transformation and why it is an active one?
What are the main issues while working with flat files as source and as targets ?
Do you find any difficulty while working with flat files as source and target?
What is the format of informatica objects in a repository?
Can u generate reports in Informatica?
Explain Dataware house architecture .how data flow from intial to end?
what is SDLC way of code development?
Explain target update override in informatica
What are the conditions needed to improve the performance of informatica aggregator transformation?
what is the hint? how to use it to reduce the query processing in program?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How to generate sequence numbers?
