Question: why unconnected lookup cannot be dynamic?
Answer: Unconnected lookup cannot insert values into lookup cache file as it is not possible to find out from which part of the mapping flow and the transformation that is called from and how many number of times that is called.