Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


how u know when to use a static cache and dynamic cache in
lookup transformation.

Answers were Sorted based on User's Feedback



how u know when to use a static cache and dynamic cache in lookup transformation...

Answer / neetu arora

Dynamic cache is generally used when u are applying lookup
on a target table and in one flow same data is coming twice
for insertion or once for insertion and once for updation.
Performance: dynamic cache decreases the performance in
comparision to static cache since it first looks in the
whole table tht whether data ws previously present if no
thn only it inserts so it takes much tym
Static cache do not see such things just insert data as
many tyms as it is coming.

Is This Answer Correct ?    21 Yes 1 No

how u know when to use a static cache and dynamic cache in lookup transformation...

Answer / hari

By default lookup is static.
Dynamic is used whn the records coming frm the source to
target in multiple times. i.e if
1)
emp_id=101...city=hyd...age=25...
(first this is inserted to target)
2)at second time when 101 employee is changing his city frm
hyd to chennai here we need to update the target table with
city name as chennai. thn how lookup cache knows tht a
record is updated...
3) if it is static lookup, after updating tht record it
will not refresh the lookup cache.... where as if it is
dynamic cache it will refresh the cache....
4) Based on our requirement we r going to use.....

Is This Answer Correct ?    15 Yes 1 No

how u know when to use a static cache and dynamic cache in lookup transformation...

Answer / krishna

hi neetu,
i hope you were a bit wrong.
static cache is also used to check whether row exists or
not.....
well krishna for your question on dynamic cache..
static cache is one in which data when changed in the
target table cannot be incorporated in the look up on the
fly.
when you use a dynamic cache any changes to the target
table gets reflected in the lookup even if the record is
being inserted or updated in the same mapping run priorly

Is This Answer Correct ?    12 Yes 0 No

how u know when to use a static cache and dynamic cache in lookup transformation...

Answer / 24/12/2007

if you need the source data after look up transformation to
transfer any other transformation more than once you can use
dynamic cache otherwise use static cache

Is This Answer Correct ?    8 Yes 4 No

how u know when to use a static cache and dynamic cache in lookup transformation...

Answer / nisith

Dear,

Whenever you required changes in your target as a lookup
than go for dynamic.Static means its a readonly why do u
want your server to busy..so stick on static only
comparison is there thats it....

Is This Answer Correct ?    1 Yes 1 No

how u know when to use a static cache and dynamic cache in lookup transformation...

Answer / nitin

I have a major doubt in static and dynamic cache.
1. what is the use of both?
2. while using dynamic cache(looking up target table),say a record is entering from source emp_id = 101, which is already in the target so this will be updated am i correct?
3. while using a static cache, same scenario as above the record also gets updated.
4. what happens in both the caches, when again a same record enters from the source
5. when will the record be rejected as a duplicate?
from my understanding, while using a static cache for already existing record in target. when a same record appears twice from source then the record that is appearing second time will be rejected as a duplicate. but in dyanmic cache it will not?.. is this true?
Please help me understand when the record will be rejected as a duplicate and when it will be updated, in case of dynamic and static cache

Is This Answer Correct ?    0 Yes 0 No

how u know when to use a static cache and dynamic cache in lookup transformation...

Answer / kareem

Here no one is understanding the question properly,In which
scenario we will go for static or dynamic lookup cache?

Is This Answer Correct ?    0 Yes 1 No

how u know when to use a static cache and dynamic cache in lookup transformation...

Answer / amit

when we use conneted type of lookup then we use dynamic
caches& when we use unconncted lookup in the modelling we
use static cache

Is This Answer Correct ?    2 Yes 10 No

how u know when to use a static cache and dynamic cache in lookup transformation...

Answer / abhsihek

Hi neetu,
as i know that dynamic lookup alway increase the perfomence
compratively static cache if i am wrong please let me know.

Is This Answer Correct ?    0 Yes 8 No

Post New Answer



More Informatica Interview Questions

How can you define a transformation? What are different types of transformations in Informatica?

10 Answers  


How does the aggregator transformation handle null values?

0 Answers  


What is a router transformation?

0 Answers  


What are partitions in informatica and which one is used for better performance?

2 Answers  


Explain the code page compatibility?

0 Answers  






I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,


can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,


Describe expression transformation?

0 Answers  


can u apply SCD2 on flat file tgt? if yes wat is the procedure?

3 Answers   Deloitte,


what is mean by throghput? in informatica

3 Answers   Cap Gemini,


In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

5 Answers   iNautix,


What are the options in the target session of update strategy transsformatioin?

2 Answers  






Categories