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 pushdown optimization and types in informatica
How to start a workflow using pmcmd command?
Explain sql transformation in script mode examples in informatica
Global and Local shortcuts. Advantages.
What is the way to execute pl/sql script using informatica mapping?
Performance tuning in UNIX for informatica mappings?
in reporting we add some new objects,how we get the count of the newly added objects to the report
what are the deliverables?in your project?
What are the features of complex mapping?
In which transformation you cannot drag ports into it?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Design a mapping to load a target table with the following values from the above source?
What you know about transaction control transformation?
Explain dynamic target flat file name generation in informatica