write sql query following table
quarter sales
q1 1000
q1 2000
q1 3000
q1 4000
q2 5000
q2 6000
q2 7000
q2 8000
q3 1000
q3 2000
q3 3000
q3 4000
q4 5000
q4 6000
q4 7000
q4 8000
i want the output format like
q1 q2 q3 q4
1000 5000 1000 5000
2000 6000 2000 6000
3000 7000 3000 7000
4000 8000 4000 8000
- 5 Answers
- 9008 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / chandu
In Expression transfermation, if( sales = q1,sales,0)
| Is This Answer Correct ? | 1 Yes | 13 No |
Post New Answer View All Answers
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Can we override a native sql query within informatica?
What is informatica?
How to Create a folder using pmrep command?
What is informatica metadata and where is it stored?
wat are deployement groups in informatica, how it will be used for developers
What is meant by a domain?
What is Index Caches size?
server hot-ws270 is connect to Repository B. What does it mean?
What all join we can perform in LOOKUP transformation?
What are the different transaction levels available in transaction control transformation?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How many input parameters can exist in an unconnected lookup?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
can you please explain me pre session and post session options?
