suppose we are using dynamic lookup cache and in lookup
condition the record is succeeded but in target it is failed
due to some reasons then what happened in the cache ?
- 4 Answers
- 7437 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / urs
When we are using the lookup cache as dynamic at first run
it will stores the all lookup table records into the cache
but second run it will check whether the incoming source
record having in the target table or not..if the record
exist in target table it will update otherwise it will
insert..this load type is done based on your condition
...nothing will happen in cache..
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / santosh kumar sarangi
Hi Urs, as you told, if record exit then it will update so
can you please clarify which one it will update cache or
target table. If it will update the target table the why we
need the update strategy T/R.
In my view, if any things updating in the dynamic look up
cache then it's responsibility of developer to update the
same in the target, other wise look up cache and target will
not be in sync,
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / Prabhu Dayal Bajpai
When a record is successfully looked up but fails during target processing, the corresponding entry remains in the cache. However, depending on your session settings, the entry might be removed after a certain period of time or based on other criteria.
| Is This Answer Correct ? | 0 Yes | 0 No |
IF THE LOOKUP CONDITION IS TRUE THEN THE RECORD IS LOADED IN
CACHE AS WELL AS IN TARGET BUT THE TARGET FAILED MEANS
RECORD ONLY LOADED IN CACHE.
IF IT IS WRONG MEANS PLEASE MAIL ME chandranmca2007@gamil.com
| Is This Answer Correct ? | 1 Yes | 4 No |
what is shared Cache. when we will use shared Cache?
What is meant by pre and post session shell command?
What are limitations of joiner transformation?
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
List the transformation in informatica.
What is batch and describe about types of batches?
without using rank transformation how can we rank items by using some other transformations
Differentiate between source qualifier and filter transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What are the new features of Power Center 5.0?
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
Teradata 
