select name as male from table where gender= 'male' union select

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?

Question Posted / vicky

4 Answers
8367 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

Please Help Members By Posting Answers For Below Questions

What is joiner transformation?

1011

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1947

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1112

What are the transformations that are not supported in mapplet?

1033

What is flashback table ? Advance thanks

1942

Enlist the various types of transformations.

1060

Enlist the differences between database and data warehouse.

1127

what is diff b/t sorter t/r and agg have the option sorter property...

2182

What are the various types of transformation?

1182

What do you understand by term role-playing dimension?

1049

How are the sources and targets definitions imported in informatica designer?

1108

Can informatica load heterogeneous targets from heterogeneous sources?

1187

How many input parameters can exist in an unconnected lookup?

1547

What all are steps in up gradation of Informatica server?

1047

Explain the shared cache and re-cache?

1122