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

How can we get multiple output values using an unconnected lookup transformation?

2 Answers   TCS,


Mention some types of transformation?

0 Answers  


What is mapplet and a reusable transformation?

2 Answers  


My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify

1 Answers   TCS,


i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

10 Answers   Emirates, IBM,






What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 Answers  


How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).

5 Answers  


How might you approve all mappings in the archive all the while?

0 Answers  


What is difference between a connected look up and unconnected look up?

6 Answers  


On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?

6 Answers  


What are the new features of the server manager in the informatica 5.0?

1 Answers  


Explain in detail scd type 2 through mapping.

0 Answers  


Categories