In case you have non-OLEDB (Object Linking and Embedding Database) source for the lookup what would you do

In case if you have non-OLEBD source for the lookup then you have to use Cache to load data and use it as source