I2 (2 points)
https://knobit.org/id/task/dm-ddl-review-deploy/I2
Also as Turtle · JSON-LD · RDF/XML
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
|---|---|
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/task/dm-ddl-review-deploy/I2 |
| rdfs:label | I2 (2 points) en |
| schema:hasPart | dm-ddl-review-deploy I2: regex check running on one engine only |
| schema:identifier | I2 |
| schema:position | 5 |
| schema:text | Expression running on one engine only, 1 each: (a) ck_fact_payment_reference uses the Postgres regex operator ~, which the generator passes through verbatim, so the constraint deploys on Postgres and fails on SQL Server, Oracle, MySQL and Databricks; (b) the fix is in the model: a portable expression (LENGTH(payment_reference) BETWEEN 8 AND 24, or comparisons and IN) as the constraint, and the pattern kept as a validity DQ rule - not a per-dialect edit of the SQL and not dropping the rule. en |
Used by
| has question | Card and account mart DDL on five engines, with its release evidence (DDL review skills) |
|---|---|
| schema:isPartOf | dm-ddl-review-deploy I2: regex check running on one engine only |