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
- 12662 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / anshita gupta
select * from city pivot(max(no) for gender in('male ','female'));
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is a sequence generator transformation?
Enlist the tasks for which source qualifier transformation is used.
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Difference between Target-based loading and constraint-based loading?
Explain direct and indirect flat file loading (source file type) - informatica
How does the aggregator transformation handle null values?
Explain pushdown optimization $pushdownconfig parameter - informatica
How do you remove duplicate records in informatica? And how many ways are there to do it?
What are the transformations that are not supported in mapplet?
What are the steps involved in the migration from older version to newer version of Informatica Server?
On which transformations you created partitions in your project?
What are the tasks that can be performed using sq?
How does a sorter cache works?
