Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10148 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / letc
Using max function for q1,q2,q3,q4 in Aggregator transformation. Use sorter before aggregator
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain the tuning lookup transformation - informatica
How do we call shell scripts from informatica?
how tokens will generate?
What is DR strategy for Informatica project?
Why do we need informatica?
Explain sql transformation in script mode examples in informatica
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to Create a folder using pmrep command?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is sorter transformation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Explain load alternative records / rows into multiple targets - informatica
How can you differentiate between powercenter and power map?
What are the measure objects?
What is a node in Informatica?
