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



suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in t..

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

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in t..

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

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in t..

Answer / chandrasekar

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

Post New Answer

More Informatica Interview Questions

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

0 Answers   Informatica,


How to Join Tables my Source is having 15 table target is one?

4 Answers   TCS,


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?

0 Answers  


how DTM buffer size and buffer block size are related

3 Answers   Wipro,


Why is meant by direct and indirect loading options in sessions?

4 Answers  


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

3 Answers   Wipro,


what is the diff b/w target load plan and cbl?

3 Answers   CTS, iGate,


What are steps to follow Informatica migration from 7x to 8x? Pls Explain...

1 Answers   CTS, TCS,


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers  


how to create user defined function (udf) in informatica

0 Answers   Informatica,


How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?

1 Answers  


Categories