Answer / annu

select decode(gender,'female',name) FEMALE,
decode(gender,'male',name) MALE from src;

Answer / voma

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'

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
=================

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.

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 ;

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

Answer / anwar

select name,
decode(gender,'male','MALE',
'female','FEMALE')GENDER from sOURCE;

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(+)

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

2 Answers   Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,

How does the server recognize the source and target databases. Elaborate on this.

1 Answers  

what is metadata?

8 Answers   Satyam,

How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,

what is upstream and downstream transformation?

7 Answers  

my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.

5 Answers   TCS,

what is mapping override?

2 Answers   Cap Gemini,

What is the function of look up transformation?

0 Answers  

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

0 Answers  

how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.

5 Answers   Keane India Ltd,

what is plsql table?

2 Answers  

How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size

1 Answers