We have the same question. You could maybe use a validation component (?). In Desktop we use the Relationship Analysis step to check key-violations and orphaned records (FK) and export to a table in a DB. You could then read this table as a CI of course.

Maybe you could use it as a validation component? But we haven't figured out how to use this in a monitoring projects.

We tried aggrigation rules, but those didn't work for our larger datasets / CI.

Keep us posted!

Hi @suryakanth.Emisha I see that you’ve created a similar post here, are there any outstanding questions, or issues on this topic? Could you please share them

@Marnix Wisselaar may I ask if you’ve had a chance to see that post?