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
- 5856 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between a connected look up and unconnected lookup?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is the difference between informatica 7.0 and 8.0?
how we can load rejected record's at run time?(not through bad files)
what is mean by complex business rule ?
What is the benefit of session partitioning?
What is blocking transformation?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What do you mean by enterprise data warehousing?
Explain your project of banking domian.
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is the sequence generator transformation in informatica?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How to load a Dimension ? and how to load a fact table?
where to store informatica rejected data?
