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
Why union transformation is an active transformation?
what are the deliverables?in your project?
Explain the code page compatibility?
What is blocking transformation?
What is the way to execute pl/sql script using informatica mapping?
What is status code in informatica?
What is sorter transformation?
How can we improve session performance in aggregator transformation?
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?
explain abt ur project architecture?
What are connected or unconnected transformations?
How to use procedural logic inside infromatica?
Explain the scenario which compels informatica server to reject files?
What is dimensional table?
What is Session and Batches?