Unconnected lookup transformations use static cache because they receive a single input value and return one output value through an expression. Static cache loads the entire lookup dataset at the start of the session and doesn't modify during execution, which suits the unconnected lookup's one-to-one mapping pattern. Dynamic cache is only available for connected lookups where you need to track inserts and updates during the session.