Shared dynamic cache?

[glenpark]

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

 

[blom0344]

A unconnected lookup will be performed only once during the session run, delivering a static set?
Aren't you going to be on very thin ice reading data from the target while at the same time inserting/updating?

Ties Blom

 

[glenpark]

Actually what I meant was is it possible to use an unconnected lookup that would refer to a cache created by a connected dynamic lookup? In this way the static, unconnected lookup would always be looking at an updated source of data instead of directly at the target. But I'm not sure if this is possible or not in Informatica.

 

[blom0344]

I think you have the conception that an unconnected lookup performs differently than a connected one. It does not, it is just not part of the mapping structure. It is executed before data is written to the target.

Ties Blom