following table
source
name gender
a1 male
a2 female
how to change 'male' to 'female' and 'female' to 'male'
- 2 Answers
- 4903 Views
- I also Faced
- E-Mail Answers
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 |
I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?
what is the difference between informatica6.1 and infomatica7.1
Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek
can u give example for factless fact table
Briefly define a session task?
What is meant by lookup transformation?
What is Data Caches size?
How can we update a record in the target table without using update strategy?
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.
5 Answers FCS, IBM, Satyam, TCS,
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?
Teradata 
