following table
source
name gender
a1 male
a2 female
how to change 'male' to 'female' and 'female' to 'male'
Answers were Sorted based on User's Feedback
Answer / koti
by using expression transformation U can apply decode
function..
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / abhishek kumar
src->sq->exp->filter->tgt
expression t/f
flag ->
iif(gender='male','female','male')
abhishek guddu
| Is This Answer Correct ? | 7 Yes | 2 No |
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
What is operational data source (ODS)?
In informatica workflow manager, how many repositories can be created?
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me
what is bridge tables in informatica
explain abt union t/r?
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
how to call lookup qualifer in unconnected look;up