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
- 9007 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / parthu
It may possible with Normalizer transformation.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can you validate all mappings in the repository simultaneously?
What happens when a session fails and you click on recover?
How to start a workflow using pmcmd command?
Can we override a native sql query within informatica?
What is confirmed fact in dataware housing?
What all join we can perform in LOOKUP transformation?
What is fact table? Explain the different kinds of facts.
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
Explain lookup transformation in informatica
How do you remove duplicate records in informatica? And how many ways are there to do it?
How to generate sequence numbers using expression transformation?
what is SDLC way of code development?
What are roles and groups and benefits of using them?
EXL informatica Questions
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
