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

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

0 Answers  

What is pmcmd command?

0 Answers  

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

What is sequence generator transformation in informatica?

0 Answers  

 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,

what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram

3 Answers  

tell me the informatica architecture

1 Answers   Banca Sella, Wipro,

What is the different lookup cache(s)?

0 Answers  

Why do we use DSS database for OLAP tools?

2 Answers  

from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic

21 Answers   Deloitte,

i have 2 session s1 execute s2 load first session fail what is the reason?

1 Answers   L&T,