topic Re: MAMisc - sequence.sas7bdat in SAS Customer Intelligence

MAMisc - sequence.sas7bdat

mb1008 — Thu, 10 Oct 2019 19:10:48 GMT

How does the sequence.sas7bdat file get incremented? Location of this file is LevN/Applications/SASCustomerIntelligence/CustomerIntelligenceCommon/Data/MAMisc/

I was under the impression that this file was incremented at the time of execution.

During recovery should the objects in this be increased to avoid overlap in the SAS Common Data Model?

Should I obtain the max value from the SAS CDM?

Re: MAMisc - sequence.sas7bdat

jpsm70 — Tue, 15 Oct 2019 20:03:09 GMT

Hello,

The increment value depends on the record type although most are incremented by one. There is a record type that is incremented by 20 as it is cached.

When are they incremented depends on the record type. For example, a cell_package_sk is incremented placed in the diagram and when execution happens.

Yes, the maximum + N (1, 10, 100, 1000, etc) is best to avoid constraint conflicts in the CDM.

Re: MAMisc - sequence.sas7bdat

mbrannon — Wed, 16 Oct 2019 14:01:56 GMT

In a DR situation, would it be best to increment by say 100 for each ? Is there documentation for best practices in a DR situation?

Thanks.

Re: MAMisc - sequence.sas7bdat

shill — Mon, 28 Oct 2019 18:21:04 GMT

Bumping up by at least 100 should be fine, especially if you're on an older (<= 5.X) version. You could make a bigger jump on more recent releases.