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 |
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
How to load the source table into flat file target(with columns) in informatica?
How many number of sessions can one group in batches?
What could be the possible resons of locks by user?
what is sql override?what is the use of it?
In which situation we will use persistant cache and shared cache in real time. plzsss answer with example
How can u work with remote database in informatica?did you work directly by using remote connections?
what are the row and column separations in Flat Files
How will the document be delivered to me?
What are the restrictions of union transformation?
difference between top down(w.h inmon)and bottom up(ralph kimball)approach?