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
- 8630 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
What is expression transformation?
Explain the shared cache and re-cache?
Write the different tools in the workflow manager?
How to load data in informatica ?
What is a stored procedure transformation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
permutations of mapplet
hi real timers . iam waiting for ur reply regarding ETL TESTING
how tokens will generate?
What is the session task and command task?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How many ways a relational source definition can be updated and what are they?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How to extract the informatica rejected data?
What is source qualifier transformation in informatica?
