I10 (1 points)
https://knobit.org/id/task/dm-physical-postgres/I10
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-physical-postgres/I10 |
| rdfs:label | I10 (1 points) en |
| schema:hasPart | dm-physical-postgres I10: current address read from key order |
| schema:identifier | I10 |
| schema:position | 14 |
| schema:text | Meaning held in physical order: v_person_current_address takes the row with the highest address_id as the current address, but the logical model holds Valid From Date, and identity order changes with back-dated corrections, migrations and parallel loads. valid_from is restored as a column, the current address is the one with the latest valid_from (BR-311), and (customer_id, valid_from) is unique. en |
Used by
| has question | Retail banking servicing schema on PostgreSQL (transactional physical design anomaly skills) |
|---|---|
| schema:isPartOf | dm-physical-postgres I10: current address read from key order |