Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Is pk in broadlogRcp incremental

Avatar

Avatar
Validate 1
Level 1
chiDing
Level 1

Likes

3 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 1
chiDing
Level 1

Likes

3 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
chiDing
Level 1

02-11-2020

we are currently developing a component that moves the data from Adobe campaign database to somewhere else in nearly realtime for dataware housing purpose. 

 

We cannot use CDC technology such as Debezium for some technical constraints, so this leaves us only one option that polls the adobe database directly. we need to capture new record as well as the update on a particular delivery(such as status change: fail, success, pending etc.)

 

One solution is to poll "TSLASTMODIFIED" timestamp, and keep track of the max "IBROADLOGID".

If one record has IBROADLOGID > last MAX (IBROADLOGID) then it is a new record, then do some logic

if one record has IBROADLOGID <= last MAX(IBROADLOGID),then it is an update, then do some logic.

 

in order for this to work, i need to make sure the IBROADLOGID is incremental, i assume it is using a database sequence, but i can't find any details about it.

 

while checking existing records in our production database. 

I have noticed that record  1238949607 created before 1238949604, but the ID is greater than the second, which doesnt seems like the id is incremental. 

I am not sure if it is Adobe gets the id from sequence first, then do the insertion ? this happens because the insertion might depends on the delivery?

chiDing_0-1604370818020.png

 

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

263 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile

Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

78 likes

Total Posts

263 posts

Correct Reply

84 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
MVP

02-11-2020

Hi @chiDing - the pk for nms:broadLogRcp is based on the sequence NmsBroadLogId. This sequence is shared amongst a number of other tables as well so its not exclusive to broadLogRcp.The table below is based on release 9032 and can change depending on your version.

Darren_Bowers_0-1604376507391.png

Cheers

Darren

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1000
Employee
Sukrity_Wadhwa
Employee

Likes

143 likes

Total Posts

866 posts

Correct Reply

35 solutions
Top badges earned
Validate 1000
Validate 500
Validate 250
Validate 100
Validate 25
View profile

Avatar
Validate 1000
Employee
Sukrity_Wadhwa
Employee

Likes

143 likes

Total Posts

866 posts

Correct Reply

35 solutions
Top badges earned
Validate 1000
Validate 500
Validate 250
Validate 100
Validate 25
View profile
Sukrity_Wadhwa
Employee

11-11-2020

Hi @chiDing,

Was the given solution helpful to resolve your query? Do let us know.

Thanks!