Custom input for validation component

Question

How can I map custom input parameter for Validation component in Ataccama One Web UI?

joyce · Accepted Answer

Hi@vkumar192! Separate DQ rules must be created for each range check.It is not possible to parameterize validation components. Having separate DQ rangerules will help to identify rule logic in the Monitoring Project Report tab and the Post-Processing Plan.For example, if there is a single DQ rule reused for several range checks. The Monitoring Project Report tab, will have several DQ checks with the same name but varying rule logic or ranges. It would be difficult to differentiate between the rules.Additionally, the Post-Processing Plan writes the DQ rule names per invalid record. If the same DQ rule is reused, the DQ rule name would not be very helpful in identifying why a record is invalid. Having separate DQ range checks, allows users to easily identify why a record is invalid based on the DQ Rule Name applied. See example below:Reuse of a single DQ range checkinvalid records export:DQ Rule NameRecord ValueRecord IDInvalid DQ Rule ExplanationDQ Range Check101InvalidDQ Range Check202InvalidDQ Range Check303InvalidUsing separate DQ range checks invalid records export:DQ Rule NameRecord ValueRecord IDInvalid DQ Rule ExplanationValue Less Than 5101Greater_than_5Value Less Than 10202Greater_than_10Value Less Than 15303Greater_than_15Hope this helps!

vkumar192 · Answer

I am trying to create a DQ evaluation rule where we can use custom input from users in our rules for some special DQ rules like domain of values check where user will provide the domain values during assigning the rule in monitoring project and based on that the evaluation should run and provide the DQ result.

That’s why I was trying to create a validation component which can accept custom values as parameter and itegrate it with the DQ evaluation rule.

Hope this helps.

Custom input for validation component

3 replies

Reply

DQ Rule Name	Record Value	Record ID	Invalid DQ Rule Explanation
DQ Range Check	10	1	Invalid
DQ Range Check	20	2	Invalid
DQ Range Check	30	3	Invalid

Reply

Sign up

Login to the Ataccama Community

Scanning file for viruses.

This file cannot be downloaded