Skip to main content

 

Hello,

I am new to Ataccama One and had a question around using the DQ rules in other ETL tools and integrations. It’s my understanding that a DQ rule returns whether the inputs are valid\invalid and it can be called as a web service using DQ firewalls. Is there a way to extend this logic to apply a fix to the input and returning this fix for invalid inputs ? Can this be exposed and reflected in the DQ firewall ? Do we need to build a component rule for this or can this be achieved using rule variables \ parameters ? It is not clear to me when parameters and variables are typically used in rule configuration.

 

Regards,

Ihab

Hi Ihab,
Ataccama rules are meant to perform DQ evaluation and return one of the results\explanations based on defined conditions and rule logic. Rules used, for example, in monitoring project or exposed through DQF always return pre-defined set of attributes which includes explanation, score, dimension results.
So while you can return a info about what’s actually wrong through explanations field you can’t return a fixed version of the input.
To achieve that you might have to build a custom set of components/online services (outside of DQF context) using ONE Desktop application that would try to suggest a fix based on the input and results of condtion evaluation.
I hope this answers your question.
Ivan


Reply