how u know when to use a static cache and dynamic cache in
lookup transformation.

Answer Posted / nisith

Dear,

Whenever you required changes in your target as a lookup
than go for dynamic.Static means its a readonly why do u
want your server to busy..so stick on static only
comparison is there thats it....

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a repository? And how to add it in an informatica client?

638


What is the use of transformation?

565


can u give example for factless fact table

5503


What is substr in informatica?

656


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1661






 Informatica Checkpoints

2847


Explain the features of connected and unconnected lookup.

529


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1192


what is the Default Source Option For Update Strategy Transformation?

745


Explain the informatica workflow?

577


Which files are created during the session rums by informatics server?

696


Target increases every day even though no new record was inserted

1098


Why filter transformation is an active one?

553


What do you mean incremental aggregation?

615


Write the program through which the records can be updated?

502