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

Why union transformation is an active transformation?

751


what are the deliverables?in your project?

1769


Explain the code page compatibility?

731


What is blocking transformation?

802


What is the way to execute pl/sql script using informatica mapping?

1082






What is status code in informatica?

681


What is sorter transformation?

681


How can we improve session performance in aggregator transformation?

760


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

1869


explain abt ur project architecture?

1844


What are connected or unconnected transformations?

721


How to use procedural logic inside infromatica?

733


Explain the scenario which compels informatica server to reject files?

753


What is dimensional table?

707


What is Session and Batches?

773