when we use conneted type of lookup then we use dynamic caches& when

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

Question Posted / amit

Answer Posted / amit

when we use conneted type of lookup then we use dynamic
caches& when we use unconncted lookup in the modelling we
use static cache

Is This Answer Correct ?

2 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What is dimensional table? Explain the different dimensions.

1123

What is the command used to run a batch?

1011

What are the issues you have faced in your project? How did you overcome those issues?

2308

What is the cumulative sum and moving sum?

1154

How to elaborate powercenter integration service?

1090

Explain informatica architecture - version 8 / 9

1043

Tell me about Propagate functions in informatica

885

Enlist the differences between database and data warehouse.

1063

In warehouses how many schemas are there?

1029

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2071

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1082

What can we do to improve the performance of informatica aggregator transformation?

1057

Why sorter is an active transformation?

1144

What are the components of workflow manager?

1036

How can we use mapping variables in informatica? Where do we use them?

1121