what is the difference between static and dynamic

Answers were Sorted based on User's Feedback



what is the difference between static and dynamic..

Answer / rajendra

Static:It is the tempoarary data to store
we cant update during the loading time
Dynamic:we update the during the data loading

Is This Answer Correct ?    24 Yes 4 No

what is the difference between static and dynamic..

Answer / nagaraju bhatraju

Uncached lookup: The informatica server doesnot build a
cache for temporary starage of data. Wenever it need to
refer to the look up table, it scans the source directly.

Dynamic Cache: The informaatica server builds a cache of
the source wen the workflow runs for the first time and it
updates the cache records dynamically after each row it
loads to the target. Means, if a target row gets updated,
the dynamic cache also gets updated automatically after
that particular row comitted in the target.

or
Dynamic cache - can be configured as connected lookup only.
It does not support lookup on flat file. Can have only
equality operator in lookup condition.

Static cache - can be configured as connected as well as
unconnected lookup. Supports lookup on flatfile. Can have
any relational operator in lookup condition.

Is This Answer Correct ?    5 Yes 2 No

what is the difference between static and dynamic..

Answer / deepthi

there is a correction in dynamic cache: 3rd point

dynamic cache can be used to unconnected tr.provided
unconnected lkp based on relational type.

Is This Answer Correct ?    3 Yes 2 No

what is the difference between static and dynamic..

Answer / deepthi

static cache:

1.static cache remains same during the session run
2.static can be used to relational and falt file lookup
types
3.static cache can be used to both unconnected and
connected lookup transformation
4.we can handle multiple matches in static cache
5.we can use other than relational operators like <,>,<=,>=
&=

Dynamic cache:

1.dynamic cache changes durig session run
2.dynamic cache can be used to only relational lookup types
3.Dynamic cache can be used to only connetced lookups
4.we cannot multiple matches in dynamic cache
5.we can use only = operator with dynamic cache.

Is This Answer Correct ?    4 Yes 5 No

Post New Answer

More Informatica Interview Questions

How to join three sources using joiner?

0 Answers  


When you move from devel to prod how will you retain a variable

1 Answers  


What is the reusable transformation?

0 Answers  


What is resilience time?

0 Answers  


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

0 Answers  






Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,


What are the reusable transforamtions?

2 Answers  


what is the significance of newlookup port in dynamic look up

1 Answers   IBM,


What is informatica? Why do we need it?

0 Answers  


in performance wise union is past,union all is past

2 Answers  


what happens when a batch fails?

3 Answers  


write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,


Categories