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

scenario

1 Answers  


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

0 Answers  


How to improve the session performance in informatica?

3 Answers   Accenture,


Kimball and Inmon methodologies?

2 Answers  


how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.

5 Answers   Keane India Ltd,






What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.

4 Answers  


How to create Target definition for flat files?

0 Answers   Informatica,


what is difference between dimention table and fact table?

1 Answers  


When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?

1 Answers  


How to list Top 10 salary, without using Rank Transmission?

16 Answers   Infosys,


Describe an informatica powercenter?

0 Answers  


What is the need of an ETL tool?

0 Answers   Informatica,


Categories