Interested to Buy Any Domain ? << Click Here >> for more details...
wtite sql query following table are
city gender no
chennai male 40
chennai female 35
bangalore male 10
bangalore female 25
mumbai female 15
i want the output?
city male female
chennai 40 35
bangalore 10 25
mumbai null 15
- 3 Answers
- 7589 Views
- Bank Of America, I also Faced
- E-Mail Answers
Answer Posted / santosh kumar sarangi
select city,max(decode(gender,'male',no)) as male,
max(decode(gender,'female',no)) as female from table_name
group by city
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the different transaction levels available in transaction control transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
How to generate sequence numbers using expression transformation?
What is the difference between informatica 7.0 and 8.0?
Write the program through which the records can be updated?
4 yrs etl devloper roles and responsibilities?any body give solutions
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Briefly define a session task?
Mention few power centre client applications with their basic purpose?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Could you explain what is enterprise data warehouse?
What do you mean by worklet?
How does the aggregator transformation handle null values?
How can we create index after completion of load process?
Explain constraint based loading in informatica
