Task Factory Advanced lookup transform: Clear cache
Add a property to the advanced lkp transform that allows the developer to keep and share the cache within a package. In the current version the cache gets cleared after use and you have to make a other instance of the cache with the same data, this is a bit annoying with large fact tables.
is there any plans updating this component?
Best regards Eirik
Mathieu Longpré commented
I would like to have a status updated on this issue? I didnt see the lookup task updated in the last release. Please let me know.
what is the status of this issue? Still under review?
The current version also cause a another problem, since we can't reuse the cache - we try to add the population of the cache in a for each loop container. The firs loop is ok, but the second failes massive with: Failed to setup cache location: System.ArgumentException: An item with the same key has already been added...
Kjetil Blomsøy commented
Even better enhancement would be to make the cache reusable for several packages. In case of a daily load of a datamart where we load several fact tables, it can be rather waste of time to recache something several times even cross packages.