Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between static and dynamic
- 4 Answers
- 25691 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 you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com
How do we call shell scripts from informatica?
Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?
What is workflow manager?
Define the various join types of joiner transformation?
how to join the two flatfiles using the joiner t/r if there is no matching port?
suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer
Is there any model difference between ODS and DWH
On which transformations you created partitions in your project?
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?
i have 2 session s1 execute s2 load first session fail what is the reason?
Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks
Teradata 
