Hi can any one tell me the difference between persistence
and dynamic caches? On which conditions we are using these
caches?
Answer Posted / srinu
Dynamic:--
1)When you use a dynamic cache, the Informatica Server
updates the lookup cache as it passes rows to the target.
2)In Dynamic, we can update catch will New data also.
3) Dynamic cache,Not Reusable
(when we need Updated cache data, That only we need Dynamic
Cache)
Persistent:--
1)a Lookup transformation to use a non-persistent or
persistent cache. The PowerCenter Server saves or deletes
lookup cache files after a successful session based on the
Lookup Cache Persistent property.
2) Persistent, we are not able to update the catch with New
data.
3) Persistent catch is Reusable.
(When we need Previous Cache data, That only we need
Persistent Cache)
I think it will help you.
Any,,,??,,,or ,,corrections let me know,,,,,,,
srinu.srinuvas@gmail.com
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Please let me know how to make Data masking in informatica..
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How do you load unique records into one target table and duplicate records into a different target table?
What do you mean by worklet?
What are the new features of Power Center 5.0?
What are the different options available for update strategy?
Differences between version 7.x and 8.x.
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How to implement security measures using repository manager?
what is the difference between informatica6.1 and infomatica7.1
Does an informatica transformation support only aggregate expressions?
What are the components of Informatica? And what is the purpose of each?
What is a stored procedure transformation?
How can repository reports be accessed without sql or other transformations?
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