Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between static and dynamic
- 4 Answers
- 25327 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Can we override a native sql query within informatica?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.
which one is better performance wise joiner or look up
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
What is a snowflake schema?
i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
Define filter transformation?
If u r using dynamic cache lookup port will be thier in thet which option u will select
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How
Teradata 
