I7 (2 points)
https://knobit.org/id/task/dm-ddl-review-deploy/I7
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/I7 |
| rdfs:label | I7 (2 points) en |
| schema:hasPart | dm-ddl-review-deploy I7: event timestamp without a zone, value date as a timestamp |
| schema:identifier | I7 |
| schema:position | 10 |
| schema:text | Time zone and business dates, 1 each: (a) dim_account.created_at is a TIMESTAMP with no zone written in local time by load jobs in Tallinn and Stockholm, so it is ambiguous and incomparable - TIMESTAMP WITH TIME ZONE, or UTC with the convention in the column comment; (b) fact_payment.payment_value_date is a TIMESTAMP although a value date is a business date, so the reconciliation's = DATE '2026-03-31' misses rows loaded at 23:30 - DATE. 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 I7: event timestamp without a zone, value date as a timestamp |