I suggest you ...

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.

47 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Eirik Kristiansen shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

5 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Mathieu Longpré commented  ·   ·  Flag as inappropriate

    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.

  • Eirik Kristiansen commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base