I6 (2 points)
https://knobit.org/id/task/dm-ddl-review-deploy/I6
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/I6 |
| rdfs:label | I6 (2 points) en |
| schema:hasPart | dm-ddl-review-deploy I6: collation deciding what the IBAN key means |
| schema:identifier | I6 |
| schema:position | 9 |
| schema:text | Collation changing what a key means, 1 each: (a) uk_dim_account_nk is on account_number, which arrives upper case without spaces from core banking and lower case in groups of four from the mobile channel; on Postgres (case-sensitive) the two spellings are two accounts, on the SQL Server copy (database default Latin1_General_CI_AS) case is ignored but the spaces still split them - the key's meaning is a server setting nobody chose; (b) the fix makes it a decision in the model: the IBAN normalised on load (upper case, spaces removed) so the key does not depend on collation, with the collation named in physical_options where the engine accepts it. 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 I6: collation deciding what the IBAN key means |