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?
Answers were Sorted based on User's Feedback
Answer / annu
select decode(gender,'female',name) FEMALE,
decode(gender,'male',name) MALE from src;
Is This Answer Correct ? | 1 Yes | 0 No |
use router transformation, In that 2 groups
1 is male, 2 is female,
target is single, but we drag the table twice
In that router 1st group condition
select * from table where gender='male'
2nd group condition
select * from table where gender='female'
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / moorthy g
Source-SQ-Exp-Rtr-Tgt(twice)
Exp:
Flag: DECODE(True, gender='MALE', 'Y','N')
RTR:
Make It Two Group
Flag value is Y then Male is one group.
Defaull is Female
Tgt:
Make It Two;
male - Tgt1
female - Tgt2
=================
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / jaspreet banga
after source qualifier, Use an expression transformer , in
that take an variable port name 'FLAG', and in that use the
decode function as 'FLAG = DECODE(GENDER=MALE,'M','F')'.
after that place an router transformer and for each flag
condition use seperate instance of target and hence you
will get what you want.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / krishna
select * from (select distinct name male from fm where
gender='male'),(select distinct name female from fm e
where gender='female');
select decode(gender,'female',name)female,decode
(gender,'male',name)male from fm ;
Is This Answer Correct ? | 3 Yes | 4 No |
Answer / murali udayagiri
You can use the below query in SQ trans if the source is
relational, if not u can do it in expr trans.
select coalesce((case when gender='male' then ename
end),',')||','||
coalesce((case when gender='female' then ename
end),'###') "male,female" from temp_emp1;
Thanks,
Murali Udayagiri
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / anwar
select name,
decode(gender,'male','MALE',
'female','FEMALE')GENDER from sOURCE;
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / star
Not sure if this has to be solved by SQL or by informatica -
and source is a table or file.
select * from (select lead(gender,0,0) over (partition by
gender), lead(gender,1,0) over (partition by gender) from
table1) where rownum=1
union all
select t1.name, t2.name from
(select name,row_number() over (partition by name) from
table1 where gender='male') t1,
(select name,row_number() over (partition by name) from
table1 where gender='female') t2
where
t1.name(+) = t2.name(+)
Is This Answer Correct ? | 0 Yes | 2 No |
What is the need for an etl tool?
What is session task and command task?
What are the designer tools for creating tranformations?
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
can we see default group,when we use router?if yes how?
what is the flow?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is blocking transformation?
Mention a few design and development best practices for informatica?
what is difference between COM & DCOM?
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
what is service oriented architecture in Informatica 8 version
1 Answers Cap Gemini, IBM, Systech, TCS,