Our team has just started using reconciliation project in Ataccama ONE UI, just wanted to confirm if we can apply a DQ rule on reconciliation projects, you can take a requirement e.g. if source data is having Wed as a record in an attribute and target is having Wednesday as a record in an attribute with same name, it shouldn't be highlighted as a different record.
Solved
Can we apply a DQ rule on reconciliation project in Ataccama ONE UI
- Data Pioneer
- 9 replies
Best answer by anna.spakova
Hi
thank you for your question. Unfrotunately this is not possible. For more specific requirements, I would recommend using the standard monitoring projects - you can create a join dataset using either SQL CIs or VCI and use those in the project.
Specifically, the recon. project - they work the way that they compare the profiling results of the datasets - so the comparison isn’t done ona record level but it is only comparing the statistics from the profiling (patterns, masks, number of records, ...). So it gives you just a high-level idea of what is wrong.
Let me know if this answers your question.
Kind regards,
Anna
+3- Ataccamer
- 211 replies
- Answer
Hi
thank you for your question. Unfrotunately this is not possible. For more specific requirements, I would recommend using the standard monitoring projects - you can create a join dataset using either SQL CIs or VCI and use those in the project.
Specifically, the recon. project - they work the way that they compare the profiling results of the datasets - so the comparison isn’t done ona record level but it is only comparing the statistics from the profiling (patterns, masks, number of records, ...). So it gives you just a high-level idea of what is wrong.
Let me know if this answers your question.
Kind regards,
Anna
Login to the Ataccama Community
No account yet? Create an account
For Ataccama Customers and Partners
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.