how can we check whether a particular cache is static or
dynamic?
Answer / praveen n
Double click the lookup transformation, check the properties
tab, if check port of dynamic lookup cache selected or not,
if it is selected it is dynamic cache and if not it is static
Static cache: it is read only and persistent
Dynamic cache: it is changing during the session runs.
Thanks
Praveen
Is This Answer Correct ? | 20 Yes | 0 No |
How to list Top 10 salary, without using Rank Transmission?
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
How do you implement scheduling in Informatica?
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
While importing the relational source defintion from database,what are the meta data of source U import?
What are different types of transformations available in informatica?
what are the different types of transformation available in informatica and what are the mostly used ?
What will be the approach?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
what is mapping parameter?
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?
where actually the usage of push down optimization happens...