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
- 10300 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
How can you validate all mappings in the repository simultaneously?
What is a surrogate key?
What all join we can perform in LOOKUP transformation?
What are the prerequisite tasks to achieve the session partition?
What is the function of aggregator transformation?
Is it possible to use a client with different version than that of its Informatica server?
what is song in infrmatica...?
What is difference between a gateway node and worker node?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What are roles and groups and benefits of using them?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Target increases every day even though no new record was inserted
What is informatica? Why do we need it?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
