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
- 11265 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
have u done any performance tuning? how u ll do?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
COM components can be used in Informatica
How union transformation is used?
What is sorter transformation?
What is the use of code page?
What is the command used to run a batch?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
How to create the source and target database connections in server manager?
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
Plz can any one say me how to get the informatica certification materials and dumps
How to load the data from people soft hrm to people soft erm using informatica?
What are the settings that you use to configure the joiner transformation?
What is data transformation manager process?
How to extract the informatica rejected data?
