Interested to Buy Any Domain ? << Click Here >> for more details...
following table
source
name gender
a1 male
a2 female
how to change 'male' to 'female' and 'female' to 'male'
- 2 Answers
- 5854 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 |
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
What are the different options available for update strategy?
What is an aggregator transformation? it is active why cant it be passive explain?
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
Could you explain what is enterprise data warehouse?
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
What are the different types of repositories created using informatica?
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
Global and Local shortcuts. Advantages.
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
Teradata 
