Is there any way to switch caching setting on the lookup up component on-the-fly? I have a lot of lookup components that I want to use full caching setting - some times I know that there will not be a lot of data - so N lookups or partial
caching would be better. I could indicate this by using a variable - I could use a conditional split to make 2 paths - I could make 2 different lookup components but these two cannot point to the next task in the flow since it seams that
all data flow task only take one input path.
I could really also use a way to flush the cache when ever a row value changes. In this way I could order the data by Company, and have it use full caching but flush the cache whenever the company id changes. Is this in any way possible?
Thank you in advance
View Complete Post