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
- 7953 Views
- I also Faced
- E-Mail Answers
Answer Posted / qlikstar
Select year,
sum(case when quarter = 'first' then amount end) AS q1_amount,
sum(case when quarter = 'second' then amount end) AS q2_amount,
sum(case when quarter = 'third' then amount end) AS q3_amount,
sum(case when quarter = 'fourth' then amount end) AS q4_amount
from table
group by year order by year
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is Data Caches size?
What is mapplet in informatica?
On which transformations you created partitions in your project?
What are the types of caches in lookup? Explain them.
scenario where i can use only concurrent execution of workflow.
What is meant by LDAP users?
What is complex mapping?
What is lookup transformation?
Explain load alternative records / rows into multiple targets - informatica
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is joiner change?
How to improve the performance of a session using sorter transformation?
In informatics server which files are created during the session rums?
Why update strategy and union transformations are active? Explain with examples.
Can we override a native sql query within informatica?
