Interested to Buy Any Domain ? << Click Here >> for more details...
wt is Dynamic lookup Transformation?
when we use?how we use?
- 2 Answers
- 25465 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / padmavathi
What Ashis told is Exactly correct apart of this Actually
when lookup table contains less data then we will go for
the Dynamic Lookup cache, performance increases.If large
data is there means its better to go for static cache.
| Is This Answer Correct ? | 20 Yes | 6 No |
Post New Answer View All Answers
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What does reusable transformation mean?
What is depict expression change?
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
wat are deployement groups in informatica, how it will be used for developers
Explain sql transformation in script mode examples in informatica
Explain the code page compatibility?
Under what condition selecting sorted input in aggregator may fail the session?
What is the difference between a connected look up and unconnected lookup?
Mention few power centre client applications with their basic purpose?
What is meant by incremental aggregation?
What are ETL Tools?
What is native users?
What is the benefit of session partitioning?
Explain the use of aggregator cache file?
