BookmarkSubscribeRSS Feed
mb1008
Calcite | Level 5

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?

3 REPLIES 3
jpsm70
SAS Employee

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.

 

 

mbrannon
Calcite | Level 5

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.

shill
SAS Employee
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.

Register today and join us virtually on June 16!
sasglobalforum.com | #SASGF

View now: on-demand content for SAS users

How to improve email deliverability

SAS' Peter Ansbacher shows you how to use the dashboard in SAS Customer Intelligence 360 for better results.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 888 views
  • 0 likes
  • 4 in conversation