knobit.org

Maps sources to targets without losing value, and reconciles on value

edu:LearningOutcome edu:Skill

https://knobit.org/id/outcome/NO-2

Also as Turtle · JSON-LD · RDF/XML

dcterms:descriptionStage 2 of the data-integration skill: Maps sources to targets without losing value, and reconciles on value; produces 02-mapping/mapping.yaml. en
dcterms:identifierNO-2
dcterms:licensehttps://creativecommons.org/licenses/by/4.0/
has prerequisiteProfiles sources for what they hold, including how their meaning changed
includes knobitRecognises a default inventing a business fact
includes knobitRecognises a time zone dropped from a timestamp
includes knobitExplains currency minor units
includes knobitExplains a percent-to-fraction scale change of a field
includes knobitRecognises an unmapped mandatory target column
includes knobitRecognises a lossy amount conversion
includes knobitRecognises value date and booking date confused
includes knobitRecognises a key collision across sources
includes knobitRecognises a mapping ignoring a meaning change
includes knobitRecognises an unspecified transformation
includes knobitRecognises a target narrower than its source
includes knobitRecognises a transformation on a column the source lacks
includes knobitConverts amounts by each currency's minor units
includes knobitExplains the source-to-target mapping contract
includes knobitExplains booking date, value date and time zones
includes knobitRecognises a reconciliation by count only
includes knobitRecognises a source value with no target value
includes knobitReconciles a migration per currency from the data
owl:sameAshttps://bitbucket.org/reffa/ontology/id/outcome/data-integration/02-source-to-target-mapping
rdfs:labelMaps sources to targets without losing value, and reconciles on value en
rdfs:labelVastendab allikad sihtidele väärtusi kaotamata ja kontrollib vastavust väärtuste tasandil et
related topicData integration and interoperability (DAMA-DMBOK2 chapter 8)

Used by

assesses learning outcomeLeasing contracts from two systems into one table - key collision, dropped offset and a percent cut-over (mapping on value)
assesses learning outcomeCard settlement file to card transactions - minor units and a reconciliation on counts (mapping anomaly skills)
has prerequisiteDesigns flows that survive retries, disorder, late data, corrections and deletes
has prerequisiteMaps internal data to ISO 20022 elements by meaning, keeping structure
includes learning outcomeLearning path: Data integration and interoperability
related learning outcomeStage 2 — Source-to-target mapping
related learning outcomeSource-to-target mapping anomaly checklist
schema:itemhttps://knobit.org/id/path/data-integration/NO-2