Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 8264 Views
- TCS, I also Faced
- E-Mail Answers
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
In how many ways we can create ports?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How to generate sequence numbers?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How can we store previous session logs?
What is the difference between informatica 7.0 and 8.0?
What is a joiner transformation and why it is an active one?
what is index?how it can work in informatica
What does update strategy mean, and what are the different option of it?
What are the reusable transformations?
How does a rank transform differ from aggregator transform functions max and min?
What is the need of etl tools?
Target increases every day even though no new record was inserted
Global and Local shortcuts. Advantages.
Can u generate reports in Informatica?
