How will you display "Mr" for male & "Mrs" for female in
target table?
Answer Posted / giri
Use Expression Transformation
Add new Field
Condition
IIf(fieldname='male','Mr','Mis')
This field Check Variable then
add newfield Concat(newfield,first name)
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is a sequence generator transformation?
How would you copy the content of one repository to another repository?
What is rank index in rank transformation?
Can we get 1st record through Informatica(without sequence number).
Enlist few areas or real-time situations where informatica is required.
What is standalone command task?
How can you generate reports in informatica?
Explain the different lookup methods used in informatica?
What is domain and gateway node?
Mention some types of transformation?
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
is it possible to index the data in cache of lkp transformation ?
without table how to come first record only in oracle?
What are the different transaction levels available in transaction control transformation?
What is the difference between informatics 7x and 8x and what is latest version?