how u know when to use a static cache and dynamic cache in
lookup transformation.

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


Please Help Members By Posting Answers For Below Questions

How do you use reject loader.

2331


What is the difference between stop and abort in informatica

876


Design time, run time. If you don't create parameter what will happen

1634


Which are the different editions of informatica powercenter that are available?

805


What is the commit type if you have a transaction control transformation in the mapping?

842


Explain joiner transformation in informatica

899


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

8458


How to update a particular record in target with out running whole workflow?

1368


What are the various types of transformation?

896


How does the aggregator transformation handle null values?

926


How many ways a relational source definition can be updated and what are they?

802


What is the status code in stored procedure transformation?

908


What are ETL Tools?

858


Describe expression transformation?

876


what is unit testing?tell me proceedure

1992