Hello,
Ok so I need a little help with a problem conceptually here. I'm constructing a mapping that loads a type 2 slowly changing dimension. Which means I have to use a dynamic lookup against the target table to synchronize inserts/updates between it and the lookup cache.
Now, I have conditions which require me to pull column data out of the target table in the same pipeline. Ideally I could utilize lookups against the same dynamic cache but not sure if this is possible with unconnected static lookups? If anyone has had any experience with this, please let me know how it went.
Thanks,
Glen
Ok so I need a little help with a problem conceptually here. I'm constructing a mapping that loads a type 2 slowly changing dimension. Which means I have to use a dynamic lookup against the target table to synchronize inserts/updates between it and the lookup cache.
Now, I have conditions which require me to pull column data out of the target table in the same pipeline. Ideally I could utilize lookups against the same dynamic cache but not sure if this is possible with unconnected static lookups? If anyone has had any experience with this, please let me know how it went.
Thanks,
Glen