I2 (2 points)

https://knobit.org/id/task/dq-rules/I2

dcterms:license	https://creativecommons.org/licenses/by/4.0/
owl:sameAs	https://bitbucket.org/reffa/ontology/id/task/dq-rules/I2
rdfs:label	I2 (2 points) en
schema:hasPart	dq-rules I2a: set rule written as a row rule
schema:hasPart	dq-rules I2b: expression unable to run
schema:identifier	I2
schema:position	5
schema:text	1 each: (a) DQ-003 is scope row with a uniqueness expression; uniqueness cannot be judged one row at a time, so it becomes a set check returning the duplicates; (b) DQ-010's expression is written in business term names and in Postgres regex syntax, neither of which will run on Snowflake - rewritten in physical column names and portable syntax. en

Used by

has question	Loan application data quality rules on Snowflake (DQ rule anomaly skills)
schema:isPartOf	dq-rules I2a: set rule written as a row rule
schema:isPartOf	dq-rules I2b: expression unable to run