knobit.org

Proves each load complete and reconciles to the ledger where differences cannot hide

edu:LearningOutcome edu:Skill

https://knobit.org/id/outcome/WO-4

Also as Turtle · JSON-LD · RDF/XML

dcterms:descriptionStage 4 of the dw-bi skill: Proves each load complete and reconciles to the ledger where differences cannot hide; produces 04-population/population.yaml. en
dcterms:identifierWO-4
dcterms:licensehttps://creativecommons.org/licenses/by/4.0/
has prerequisiteIntegrates processes through dimensions conformed by grain and key
includes knobitRecognises a warehouse load with no control totals
includes knobitRecognises load rejects dropped
includes knobitRecognises late data silently excluded
includes knobitRecognises a reconciliation tolerance with no rationale
includes knobitRecognises a reconciliation passing on offsetting differences
includes knobitRecognises data delivered with no as-of date
includes knobitRecognises a manual adjustment outside any control
includes knobitRecognises a reconciliation with no owner or frequency
includes knobitReconciles per general ledger account
includes knobitBrings a manual adjustment under a recorded control
includes knobitKeeps a reconciliation tolerance unchanged to pass
includes knobitExplains warehouse load controls
includes knobitExplains reconciliation to the general ledger
includes knobitExplains data currency for consumers
owl:sameAshttps://bitbucket.org/reffa/ontology/id/outcome/dw-bi/04-population-reconciliation
rdfs:labelProves each load complete and reconciles to the ledger where differences cannot hide en
rdfs:labelTõendab iga laadimise täielikkust ja võrdleb tulemusi pearaamatuga seal, kus erinevused ei saa peituda et
related topicData warehousing and business intelligence (DAMA-DMBOK2 chapter 11)

Used by

assesses learning outcomePayments joins the bus - an Account keyed by IBAN, a file fee on payment rows and a load that does not balance (conformance, grain, load control and GL reconciliation knowledge)
assesses learning outcomeDeposits mart month-end - a reconciliation that passes because two errors cancel (population anomaly skills)
has prerequisiteSpecifies reports that show catalogue metrics honestly, dated, and only to entitled audiences
includes learning outcomeLearning path: Data warehousing and business intelligence
related learning outcomeStage 4 — Population and reconciliation
related learning outcomePopulation and reconciliation anomaly checklist
schema:itemhttps://knobit.org/id/path/dw-bi/WO-4