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 the need of etl tools?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
what is the necessity to use update strategy?(except for updates)
What are active and passive transformations?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
without table how to come first record only in oracle?
Difference between task flow and linear task flow
How do you implement configuration management in Informatica?
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.
h0w many versions have been developed of onformatica so far?