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
What are the types of schemas we have in data warehouse.
What if the source is a flat-file?
What is the difference between router and filter?
What is the difference between STOP and ABORT options in Workflow Monitor?
explain about unit testing? in real time?
Different sorts of metadata that stores in the storage facility?
Separate from a database, an information bazaar, and an information stockroom?
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.
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Define the various join types of joiner transformation?
What is the sql query overwrite in source qualifier in informatica
What is dimensional table?
How to generate sequence numbers without using the sequence generator transformation?
To import the flat file definition into the designer where should the flat file be placed?
How to update a particular record in target with out running whole workflow?