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
- 7562 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
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is informatica powercenter repository?
What is the cumulative sum and moving sum?
What is rank transformation in informatica
Difference between Target-based loading and constraint-based loading?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is an expression transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
what is size of u r database?
How can we use batches?
Explain the features of connected and unconnected lookup.
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How many numbers of sessions can one group in batches?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Explain sessions?
