Interested to Buy Any Domain ? << Click Here >> for more details...
write sql query following table
city gender no
chennai male 40
chennai female 35
bangalore male 25
bangalore female 25
mumbai female 15
i want the required output
city male female
chennai 40 35
bangalore 25 25
mumbai 15
- 5 Answers
- 12672 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / venu
select* from tablename
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
How to generate sequence numbers using expression transformation?
define galaxy repository in informatica
What are the different components of powercenter?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Explain the features of connected and unconnected lookup.
Explain about cumulative Sum or moving sum?
Differentiate between a repository server and a powerhouse?
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?
Is there any way to read the ms excel datas directly into informatica?
How to do unit testing in informatica?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is the status code in stored procedure transformation?
Make a note of the quantity vaults made in informatica?
What are Dimensional table?
What is lookup transformation?
