Post New Answer View All Answers
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 is a rank transform?
What is the difference between a connected look up and unconnected lookup?
differences between service based and product based?
Where can we find the throughput option in informatica?
What does role playing dimension mean?
What is meant by LDAP users?
What is primary and backup node?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the different types of transformation available in informatica.
Explain scd type 3 through mapping.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?