When will u go for Dynamic Cache and Persistent Cache? Pls
explain with an example?
Answers were Sorted based on User's Feedback
Answer / harish konda
Dynamic cache is used to update/insert the records into the
cache during the session run. From there we can
update/target table with the NewLookupRow values returned by
lookup.
If you want to use the same lookup cache in other mappings
also then we will go for Persistent Cache.
The difference is for eg, in the first mapping when we use
dynamic cache, when the session ends, the cache gets deleted
automatically. So to use this cache in other mappings also
check give one option "Persistent Cache".
So when we use this option, the cache in the memory gets
Saved even after session ends. From there we can use that in
other mappings.
Is This Answer Correct ? | 4 Yes | 0 No |
If the lookup cache doesnt change between mutiple runs and
if we know that the lookup data doesnt change then we will
go for Persistant cache.
If the loopup cache changes between multiple session runs
and to keep the target table and lookup cache synchronized
we will use dynamic lookup cache .
regards,
rayudu.
Is This Answer Correct ? | 7 Yes | 4 No |
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in
Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks
What are 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?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
How can repository reports be accessed without sql or other transformations?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
What is the difference between Bulk Load and Normal Load
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?