Posted: 9 Jan 2019 13:08 EST Last activity: 17 Jan 2019 17:18 EST
Is pxFactID available after writing to IH via dataset or dataflow?
After writing to IH (via a dataflow/dataset) we have a need to write additional information to a customer defined table with a FK relationship to IH Fact via the pxFactID (7.31 implementation). The current implementation performs a read from IH to determine the record just written to get the pxFactID and then insert into the customer defined table.
Is there an alternate solution that eliminated the subsequent IH read?
There is no mechanism to get the ID while writing to it via a dataset. I believe you need an ID to correlate it to another system you have. If that's the case, the typical solution is to write your own identifiers (GUID) into an additional fact attribute and use that for your correlation needs.