Start a new topic
Discussions xDM xDM - Data Certification
Answered

How to guarantee attribute unicity in a Basic table updated daily?

Hello,


I have a question about integration patterns to submit to the community.


We have a Basic table called TABLE1. Every day, we insert a copy of a table in a source application in SA_TABLE1 and submit an Integration Load.


We have two requirements:

- We would like to have the latest version of the source data in the GD_.

- We would like one column, called BK, to always be unique in GD_TABLE1, and raise an error in case of duplicate.


What settings to use on the entity to achieve this result?


Thanks.

Best Answer

Hello Logan,


1. To get only the latest data every time in GD you need to put a filter on the business view of the entity like the below one-

Semql condition -

CreationDate = CURRENT_DATE()


So that you will only show the data which is latest one.


2. Create an unique key on the attribute you want to be unique and in the stepper select the form step, then step transition validation -On step exit should be  block.  

In the form validation -
make a check on 'On data change' and 'On form open'

now whenever you enter any duplicate value you will be notified-
Let us know if you have any concern, thank you.
3 CommentsSorted by Oldest First
Answer

Hello Logan,


1. To get only the latest data every time in GD you need to put a filter on the business view of the entity like the below one-

Semql condition -

CreationDate = CURRENT_DATE()


So that you will only show the data which is latest one.


2. Create an unique key on the attribute you want to be unique and in the stepper select the form step, then step transition validation -On step exit should be  block.  

In the form validation -
make a check on 'On data change' and 'On form open'

now whenever you enter any duplicate value you will be notified-
Let us know if you have any concern, thank you.

Thanks, I see how to make the validation stronger. What are the meanings of Block, On Data Change and On Form Open?

Hello Logan,


Please follow our documentation for more details-

Stepper Block 

On form open and On data change


Thank you

Login to post a comment
More topics in xDM - Data Certification
See all 45 topics
Help Desk Software by Freshdesk