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
- 8622 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
What is the procedure for creating independent data marts from informatica 7.1?
Is it possible to use a client with different version than that of its Informatica server?
What is the session task and command task?
Explain incremental aggregation in informatica
Difference between Data and Index Caches?
How would you copy the content of one repository to another repository?
What are the advantages of using informatica as an etl tool over teradata?
how we can load rejected record's at run time?(not through bad files)
What is the command used to run a batch?
Explain the mapping variable usage example in informatica
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the measure objects?
What do think which one is the better joiner or look up?
Global and Local shortcuts. Advantages.
What is the difference between informatica 7.0 and 8.0?
