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
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Eirik Kristiansen shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    5 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      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