Answer Posted / sushma
If you configure lookup TRFM to use dynamic cache, then u
can use only = operator in the lookup condition,whereas LKP
TRFM using static cache can use any relational operator in
the lookup condition.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
wat are deployement groups in informatica, how it will be used for developers
In how many ways we can create ports?
wf dont have integration severances how you can run?
How can a transformation be made reusable?
What is dimensional table?
How do you load alternate records into different tables through mapping flow?
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
Enterprise data warehouse your projects phase by phase explain?
Difference between Data and Index Caches?
How to open an older version of an object in the workspace?
How to improve the performance of a session using sorter transformation?
What are the modules in Power Center
What happens when a session fails and you click on recover?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What does role playing dimension mean?