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

How an expression transformation differs from aggregator transformation?

0 Answers  

Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers   IBM,

How many ways are there to create ports?

0 Answers   Informatica,

How to generate or load values in to the target table based on a column value using informatica etl tool.

0 Answers   Informatica,

how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,

Can you copy the session to a different folder or repository?

1 Answers  

What is the different lookup cache(s)?

0 Answers  

TELL ME ABOUT WORK FLOW SCHEDULING?

3 Answers   TCS,

How to jion 2 tables, without using any condition?

11 Answers   Amazon,

how to call lookup qualifer in unconnected look;up

1 Answers   BirlaSoft,

Explian the Process of deployment groups in informatica

0 Answers   Informatica,

can u give example for factless fact table

2 Answers   TCS,