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
- 12838 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
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
What are the basic requirements to join two sources in a source qualifier transformation using default join?
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.
What is a repository? And how to add it in an informatica client?
What is the scenario which compels informatica server to reject files?
can we override a native sql query within informatica? Where do we do it? How do we do it?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is olap (on-line analytical processing?
What is a router transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is a stored procedure transformation?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How can we use batches?
can anyone explain me about retail domain project in informatica?
