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
- 9964 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 workflow? What are the components of workflow manager?
Explain lookup transformation is active in informatica
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is a sorter transformation?
What are the tasks that source qualifier perform?
How do you change a non-reusable transformation to reusable transformation?
Where do we use mapping variables in informatica?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How do you load only null records into target? Explain through mapping flow.
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
What is union transformation in informatica?
What is decode in informatica?
How will the document be delivered to me?
Why union transformation is an active transformation?
How would you join a node to the already existing domain?
