following source name gender ramya female ram male deesha female david ma

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 / ramu2k20

4 Answers
6922 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

following source name gender ramya female ram male deesha female david male kumar male i wa..

Answer / zer0

Create the mapping as below:

EXP1 ---> SRT1
/ \
Src --> Router Joiner ---> EXP3 ---> Targ
\ /
EXP2 ---> SRT2

Router: Filter on the basis of gender. All records with
gender male wil go into EXP1 and the records with gender
female will go into EXP2.
In EXP1 and EXP2, create a variable dummy port (Seq_Var)
with value Seq_Var+1 and an output port Seq_Out (value-
Seq_Var).
Pass the name and sequence ports from EXP1 and EXP2 to SRT1
and SRT2 (sorter) respectively.
In SRT1 and SRT2, sort on the basis of sequence.
In Joiner, use 'Full Outer Join' and keep 'Sorted Input'
checked in properties.
Pass the male name values and female name values from
joiner to EXP3 (Gather all the data). Pass all the data to
Target.

Is This Answer Correct ?

12 Yes

2 No

following source name gender ramya female ram male deesha female david male kumar male i wa..

Answer / chiky

map1
map1
1.source
2.sorter
3.filter ( gender = male)
4.connect to male_name column in target

map2
1.source
2.sorter
3.filter( gender = female)
4.connect to female_namw column in same target)

target load plan 1,2
start the load.

Is This Answer Correct ?

1 Yes

0 No

following source name gender ramya female ram male deesha female david male kumar male i wa..

Answer / 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

following source name gender ramya female ram male deesha female david male kumar male i wa..

Answer / rakesh ameta

select male,female from
(select row_number() over (order by (select 1)) as ID,names as male from gen where genders='male') a
FULL join
(select row_number() over (order by (select 1)) as ID,names as female from gen where genders='female') b
on a.id=b.id

Is This Answer Correct ?

1 Yes

2 No

Post New Answer