how u know when to use a static cache and dynamic cache in
lookup transformation.
- 9 Answers
- 24392 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / nitin
I have a major doubt in static and dynamic cache.
1. what is the use of both?
2. while using dynamic cache(looking up target table),say a record is entering from source emp_id = 101, which is already in the target so this will be updated am i correct?
3. while using a static cache, same scenario as above the record also gets updated.
4. what happens in both the caches, when again a same record enters from the source
5. when will the record be rejected as a duplicate?
from my understanding, while using a static cache for already existing record in target. when a same record appears twice from source then the record that is appearing second time will be rejected as a duplicate. but in dyanmic cache it will not?.. is this true?
Please help me understand when the record will be rejected as a duplicate and when it will be updated, in case of dynamic and static cache
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you change a non-reusable transformation to reusable transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How does a rank transform differ from aggregator transform functions max and min?
What is aggregate cache in aggregator transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
write a query to retrieve the latest records from the table sorted by version(scd)
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
Describe expression transformation?
What is the difference between a connected look up and unconnected lookup?
What do think which one is the better joiner or look up?
Can we create multiple integration service on single repository?
What is depict expression change?
How identifying bottlenecks in various components of informatica and resolving them?
