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 ?
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 |
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 |
Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How to Join Tables my Source is having 15 table target is one?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
how DTM buffer size and buffer block size are related
Why is meant by direct and indirect loading options in sessions?
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
what is the diff b/w target load plan and cbl?
What are steps to follow Informatica migration from 7x to 8x? Pls Explain...
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
how to create user defined function (udf) in informatica
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?