Skip to main content
Question

How to get PK viloation identification in Data Quality indicator in One Desktop ?


in One Desktop we will get the summary of DQ checks like if the column is empty or if the column (salary) is having greater than defined. For each and every record it will show the record which got failed in the output of Data Quality indicator . My question here is How to achieve Primary key violated here ? i will show with an example. 

 

 

Forum|alt.badge.img+2

Hello Lokeshpotti,

 

Thank you for your question. If I understand correctly the goal is to read a file and check to see if the primary key is violated by having a duplicate. This can be done in a couple of ways. One of the ways I can think of is to use a group aggregator step to check the count of the rows for each primary key and if the count is >1, then flag as a duplicate primary key. we could then bring the data back to the main flow so that we can see all of our data once again. Please see the images of how a flow like this would be created.

 

 

 

 


Thanks for quick response. i will check this and let you know. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings