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
Answer Posted / venu
select* from tablename
Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
Explain direct and indirect flat file loading (source file type) - informatica
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
How to load the data from a flat file into the target where the source flat file name changes daily?
Define sessions in informatica etl?
How do you promote a non-reusable transformation to reusable transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are the transformations that are not supported in mapplet?
What is the reusable transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is the meaning of up gradation of repository?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is union transformation in informatica?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures