Interested to Buy Any Domain ? << Click Here >> for more details...
When will u go for Dynamic Cache and Persistent Cache? Pls
explain with an example?
- 2 Answers
- 9251 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is flashback table ? Advance thanks
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Parameter and variable differences
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
Differences between version 7.x and 8.x.
What is native users?
What is a repository? And how to add it in an informatica client?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
what is degenerated dimension?
How do you load unique records into one target table and duplicate records into a different target table?
Which are the different editions of informatica powercenter that are available?
Explain the aggregator transformation?
Explain scd type 3 through mapping.
As union transformation gives UNION ALL output, how you will get the UNION output?
What is the use of transformation?
