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
- 10301 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / chandu
In Expression transfermation, if( sales = q1,sales,0)
| Is This Answer Correct ? | 1 Yes | 13 No |
Post New Answer View All Answers
How to do unit testing in informatica?
What is mapplet in informatica?
How can you increase the performance in joiner transformation?
what is the hint? how to use it to reduce the query processing in program?
Under what condition selecting sorted input in aggregator may fail the session?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What are multi-group transformations?
What is target load order?
Explain pushdown optimization and types in informatica
Explain sessions?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are the tasks that source qualifier perform?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
How do you load first and last records into target table?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
