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
- 9003 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
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Briefly explain the aggregator transformation?
which one is better performance wise joiner or look up
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is a predefined event?
If informatica has its scheduler why using third party scheduler?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is Session and Batches?
What is the meaning of decode in informatica?
What is a rank transform?
What is workflow? What are the components of workflow manager?
