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.
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.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.