following table
source
name gender
a1 male
a2 female
how to change 'male' to 'female' and 'female' to 'male'
Answer Posted / koti
by using expression transformation U can apply decode
function..
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is the function of look up transformation?
can we override a native sql query within informatica? How do we do it?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What do you mean by channel change?
Explain sql transformation in script mode examples in informatica
complex mapping ur project u r invlve can u explain and give real time example give me ?
How to elaborate powercenter integration service?
in reporting we add some new objects,how we get the count of the newly added objects to the report
what is Active lock explain
Explain the different lookup methods used in informatica?
What is a standalone command task?
Have you worked with/created Parameter file
What is a transaction control transformation?
Can you generate sequence numbers without using the sequence generator transformation?
How we can create indexes after completing the loan process?