How will you display "Mr" for male & "Mrs" for female in
target table?
Answer Posted / dragon
I agree with Rkumar.etl,
but if in the database is too old and they dont have column
flag then how you u define.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a joiner transformation and why it is an active one?
Define mapplet?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How do you handle two sessions in Informatica
In which transformation you cannot drag ports into 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 are the different versions of informatica?
How many number of sessions can one group in batches?
Explain the tuning lookup transformation - informatica
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What do you mean by blocking transformation?
During the running session, output files are created by informatica server. Enlist few of them.
Please let me know how to make encryption and decryption with example?
What are the prerequisite tasks to achieve the session partition?
How to generate sequence numbers using expression transformation?