following source
name gender
ramya female
ram male
deesha female
david male
kumar male
i want the target
male female
ram ramya
david deesha
kumar
any body give solution above question?
Answer Posted / vicky
select name as male from table where gender= 'male'
union select name as female from table where gender='female'
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is data caches/ index caches?
What is parallel processing in informatica?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Explain what are the different versions of informatica?
What are the new features of informatica 9.x at the developer level?
What is InformaticaPowerCenter?
How can we update a record in the target table without using update strategy?
How do you set a varible in incremental aggregation
What is mapplet in informatica?
how we can load rejected record's at run time?(not through bad files)
What could be the possible resons of locks by user?
Explain the difference between a data warehouse and a data mart?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is meant by incremental aggregation?