C3 (2 points)
https://knobit.org/id/task/dm-ddl-review-deploy/C3
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/C3 |
| rdfs:label | C3 (2 points) en |
| schema:hasPart | dm-ddl-review-deploy C3: production index in no model, no drift comparison |
| schema:identifier | C3 |
| schema:position | 3 |
| schema:text | Drift between database and model, 1 each: (a) ix_fact_payment_status_code exists in the production catalogue and in no model and no generated DDL (created during INC-2291), and is reported as a difference to close deliberately - into the model if it is wanted, out of the database if not - rather than debated as an indexing question; (b) nothing compares the deployed catalogue with the generated DDL, and the answer asks for a scheduled comparison (information_schema / pg_catalog, or the engine's schema-compare tooling) whose result becomes part of the stage evidence. 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 C3: production index in no model, no drift comparison |