I2 (2 points)
https://knobit.org/id/task/dii-flow-resilience/I2
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/dii-flow-resilience/I2 |
| rdfs:label | I2 (2 points) en |
| schema:hasPart | dii-flow-resilience I2a: late payment of a closed period and a correction referencing its original |
| schema:hasPart | dii-flow-resilience I2b: query-based CDC misses hard deletes, log-based CDC sees them |
| schema:identifier | I2 |
| schema:position | 5 |
| schema:text | Written answers, 1 each. (a) Q-3: neither record is dropped nor silently written into the closed October; the late payment PM-88412 keeps its value date and is loaded into the open period (November) as an adjustment, or into a correction table / October revision under the reporting rules; the correction references PM-80177 and is linked or netted against it, not loaded as an unrelated new payment or overwritten into the original. (b) Q-4: query-based CDC by last_modified cannot see hard deletes (CRM hard-deletes erased customers), and also misses intermediate changes between polls and rows whose last_modified is not set; log-based CDC reads the transaction log and sees every insert, update and delete in commit order - so keep log-based CDC, or add a periodic full key compare. en |