Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between static and dynamic
- 4 Answers
- 25693 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is lookup transformation?
Which transformation should we use to normalise the COBOL and relational sources?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Design time, run time. If you don't create parameter what will happen
How do we call shell scripts from informatica?
Why union transformation is an active transformation?
What is the use of transformation?
Explain the mapping variable usage example in informatica
What are the guidelines to be followed while using union transformation?
What is xml source qualifier transformation in informatica?
What is rank transform?
What is olap (on-line analytical processing?
What is meant by LDAP users?
How do you handle two sessions in Informatica
