I4 (2 points)
https://knobit.org/id/task/dm-ddl-review-deploy/I4
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/I4 |
| rdfs:label | I4 (2 points) en |
| schema:hasPart | dm-ddl-review-deploy I4: BOOLEAN meaning four things on five engines |
| schema:identifier | I4 |
| schema:position | 7 |
| schema:text | A type meaning something else per engine, 1 each: (a) dim_date.is_business_day BOOLEAN renders as BOOLEAN on Postgres and Databricks, BIT on SQL Server, NUMBER(1) on Oracle and TINYINT(1) on MySQL, so the calendar feed's 2 (half business day) is rejected on Postgres, silently becomes 1 on SQL Server and is stored as 2 on Oracle and MySQL - four meanings of one column; (b) the fix is in the model: a check constraint for the 0/1 domain on the engines without a boolean, and the half day raised as a domain question (a business-day type code, or a decision that it maps to 0 or 1) rather than left to each engine. 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 I4: BOOLEAN meaning four things on five engines |