{"id":60042,"date":"2020-01-28T08:53:52","date_gmt":"2020-01-28T07:53:52","guid":{"rendered":"https:\/\/www.scalefree.com\/blog\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\/"},"modified":"2026-08-13T12:12:42","modified_gmt":"2026-08-13T10:12:42","slug":"ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0","status":"publish","type":"post","link":"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\/","title":{"rendered":"Ans\u00e4tze zur Handhabung von L\u00f6schungen und \u00c4nderungen in Data Vault 2.0"},"content":{"rendered":"[vc_row type=&#8220;in_container&#8220; full_screen_row_position=&#8220;middle&#8220; column_margin=&#8220;default&#8220; column_direction=&#8220;default&#8220; column_direction_tablet=&#8220;default&#8220; column_direction_phone=&#8220;default&#8220; scene_position=&#8220;center&#8220; text_color=&#8220;dark&#8220; text_align=&#8220;left&#8220; row_border_radius=&#8220;none&#8220; row_border_radius_applies=&#8220;bg&#8220; overflow=&#8220;visible&#8220; overlay_strength=&#8220;0.3&#8243; gradient_direction=&#8220;left_to_right&#8220; shape_divider_position=&#8220;bottom&#8220; bg_image_animation=&#8220;none&#8220;][vc_column column_padding=&#8220;no-extra-padding&#8220; column_padding_tablet=&#8220;inherit&#8220; column_padding_phone=&#8220;inherit&#8220; column_padding_position=&#8220;all&#8220; column_element_direction_desktop=&#8220;default&#8220; column_element_spacing=&#8220;default&#8220; desktop_text_alignment=&#8220;default&#8220; tablet_text_alignment=&#8220;default&#8220; phone_text_alignment=&#8220;default&#8220; background_color_opacity=&#8220;1&#8243; background_hover_color_opacity=&#8220;1&#8243; column_backdrop_filter=&#8220;none&#8220; column_shadow=&#8220;none&#8220; column_border_radius=&#8220;none&#8220; column_link_target=&#8220;_self&#8220; column_position=&#8220;default&#8220; gradient_direction=&#8220;left_to_right&#8220; overlay_strength=&#8220;0.3&#8243; width=&#8220;1\/1&#8243; tablet_width_inherit=&#8220;default&#8220; animation_type=&#8220;default&#8220; bg_image_animation=&#8220;none&#8220; border_type=&#8220;simple&#8220; column_border_width=&#8220;none&#8220; column_border_style=&#8220;solid&#8220;][vc_column_text css=&#8220;&#8220; text_direction=&#8220;default&#8220;]\n<h2><span style=\"font-weight: 400;\">Ans\u00e4tze zur Handhabung von L\u00f6schungen und \u00c4nderungen in Data Vault 2.0 <\/span><\/h2>\n<p><span style=\"font-weight: 400;\">In diesem Artikel zeigen wir Ihnen, wie Sie Counter Records f\u00fcr den Umgang mit \u00c4nderungen und L\u00f6schungen in <a href=\"https:\/\/www.scalefree.com\/consulting\/data-vault-2-0\/\">Data Vault 2.0<\/a> nutzen k\u00f6nnen. Im Januar dieses Jahres haben wir einen Beitrag ver\u00f6ffentlicht, der<\/span> <a href=\"http:\/\/blog.scalefree.com\/2019\/01\/08\/driving-key-implementation-in-data-vault\/\"><span style=\"font-weight: 400;\">einen Ansatz zur Handhabung von L\u00f6schungen und Business-Key-\u00c4nderungen in Data-Vault-Beziehungen ohne vorhandenen Audit-Trail beschreibt<span style=\"font-weight: 400;\">.<\/span><\/span><\/a> <span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\">Dieser Ansatz ist eine <a href=\"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/alternative-zur-driving-key-implementierung-in-data-vault\/\">Alternative zur Driving-Key<\/a>-Struktur, die Teil der Data-Vault-Standards und eine valide L\u00f6sung darstellt. <\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\">Manchmal kann es jedoch schwierig sein, diejenigen Business Keys in einer Beziehung zu identifizieren, die sich niemals \u00e4ndern und daher bei Abfragen als Anchor Keys (Link Driving Keys) verwendet werden. Die vorgestellte Methode f\u00fcgt Counter Records f\u00fcr ge\u00e4nderte oder gel\u00f6schte Datens\u00e4tze ein, speziell bei Transaktionsdaten und stellt einen einfachen sowie pragmatischen Ansatz dar. Der Artikel warf jedoch viele Fragen auf, sorgte f\u00fcr Verwirrung und regte Diskussionen an.   <\/span><span style=\"font-weight: 400;\"><br \/>\n<\/span><span style=\"font-weight: 400;\">Ziel dieses Blogbeitrags ist es daher, tiefer in die technische Implementierung einzutauchen, deren Praxistauglichkeit wir im Einsatz best\u00e4tigen konnten.<\/span><\/p>\n<div class=\"content-list-wrapper\"><p class=\"content-heading\">In this article:<\/p><ul class=\"content-list\"><li><a href=\"#technische-implementierung-in-data-vault-2-0\">Technische Implementierung in Data Vault 2.0<\/a><li><a href=\"#fazit\">Fazit<\/a><\/ul><\/div>\n<br>\n<h2>Technische Implementierung in Data Vault 2.0<\/h2>\n<p><span style=\"font-weight: 400;\">Die folgende Tabelle zeigt eine leicht modifizierte Zielstruktur des Links aus dem<\/span> <a href=\"http:\/\/blog.scalefree.com\/2019\/01\/08\/driving-key-implementation-in-data-vault\/\"><span style=\"font-weight: 400;\">vorherigen Blogbeitrag<\/span><\/a> <span style=\"font-weight: 400;\">bei der Verwendung von Counter Records in Data Vault 2.0.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">In diesem Fall konzentrieren wir uns auf Transaktionen, die vom Quellsystem ge\u00e4ndert wurden, ohne dass Audit-Daten \u00fcber die \u00c4nderungen oder Gegenbuchungen durch die Quelle selbst geliefert werden.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Es ist wichtig zu beachten, dass der Link Verkaufspositionen speichert, indem er auf den Kunden und das Produkt verweist. Daher bilden der Link-<a href=\"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/hash-keys-in-data-vault\/\">Hash-Key<\/a> sowie das Load Date die Prim\u00e4rschl\u00fcssel (Primary Keys), da wir in diesem Fall keine konsistente, einzelne Record-ID erfassen k\u00f6nnen. Aus diesem Grund wird der Link-Hash-Key aus dem Customer-Business-Key, dem Product-Business-Key, dem Verkaufspreis und dem Transaktions-Zeitstempel berechnet.   <\/span>[\/vc_column_text][divider line_type=&#8220;No Line&#8220;][image_with_animation image_url=&#8220;29610&#8243; image_size=&#8220;full&#8220; animation_type=&#8220;entrance&#8220; animation=&#8220;None&#8220; animation_movement_type=&#8220;transform_y&#8220; hover_animation=&#8220;none&#8220; alignment=&#8220;&#8220; border_radius=&#8220;none&#8220; box_shadow=&#8220;none&#8220; image_loading=&#8220;lazy-load&#8220; max_width=&#8220;100%&#8220; max_width_mobile=&#8220;default&#8220;][vc_column_text]<i><span style=\"font-weight: 400;\">Abbildung 1: Link mit Counter Records<\/span><\/i>[\/vc_column_text][divider line_type=&#8220;No Line&#8220;][vc_column_text css=&#8220;&#8220; text_direction=&#8220;default&#8220;]Um den Link zu laden, sind die folgenden Schritte erforderlich:<\/p>\n<p><span style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Zun\u00e4chst wird gepr\u00fcft, ob eine Gegenbuchung \u00fcberhaupt notwendig ist, und diese gegebenenfalls eingef\u00fcgt, da der vorherige Schritt neue Daten aus der Staging Area in den Link l\u00e4dt. Bitte beachten Sie, dass die Ladelogik in diesem Schritt der des Standard-Link-Ladeprozesses \u00e4hnelt, jedoch einige Unterschiede aufweist:<\/span><\/span>[\/vc_column_text][divider line_type=&#8220;No Line&#8220; custom_height=&#8220;50&#8243;][image_with_animation image_url=&#8220;29609&#8243; image_size=&#8220;full&#8220; animation_type=&#8220;entrance&#8220; animation=&#8220;None&#8220; animation_movement_type=&#8220;transform_y&#8220; hover_animation=&#8220;none&#8220; alignment=&#8220;&#8220; border_radius=&#8220;none&#8220; box_shadow=&#8220;none&#8220; image_loading=&#8220;lazy-load&#8220; max_width=&#8220;100%&#8220; max_width_mobile=&#8220;default&#8220;][vc_column_text]<i><span style=\"font-weight: 400;\">Abbildung 2: Insert-Logik<\/span><\/i>[\/vc_column_text][divider line_type=&#8220;No Line&#8220; custom_height=&#8220;50&#8243;][vc_column_text css=&#8220;&#8220; text_direction=&#8220;default&#8220;]<span style=\"font-weight: 400;\">In Data Vault 2.0 soll der Counter Record diejenigen Datens\u00e4tze identifizieren, genauer gesagt die aktuellsten Datens\u00e4tze nach Link-Hash-Key, die zwar im Link existieren, aber aufgrund von L\u00f6schungen oder \u00c4nderungen nicht mehr in der Staging Area vorhanden sind. Somit werden Abfrageergebnisse mit einem Wert von -1 f\u00fcr \u201ecounter\u201c ausgeglichen, was anzeigt, dass diese Datens\u00e4tze in diesem Stadium nicht gefunden werden k\u00f6nnen. Beachten Sie, dass wir in dieser Abfrage den bestehenden Datensatz aus der Link-Tabelle im Raw Vault ausw\u00e4hlen. Wichtig ist hierbei jedoch, dass die Ankunftszeit des Datensatzes dem LDTS des tats\u00e4chlichen Staging-Batches entsprechen sollte. Daher ist das LDTS innerhalb des gezeigten Statements eine Variable mit dem Load Date des Staging-Batches:   <\/span>[\/vc_column_text][divider line_type=&#8220;No Line&#8220; custom_height=&#8220;50&#8243;][image_with_animation image_url=&#8220;29608&#8243; image_size=&#8220;full&#8220; animation_type=&#8220;entrance&#8220; animation=&#8220;None&#8220; animation_movement_type=&#8220;transform_y&#8220; hover_animation=&#8220;none&#8220; alignment=&#8220;&#8220; border_radius=&#8220;none&#8220; box_shadow=&#8220;none&#8220; image_loading=&#8220;lazy-load&#8220; max_width=&#8220;100%&#8220; max_width_mobile=&#8220;default&#8220;][vc_column_text]<i><span style=\"font-weight: 400;\">Abbildung 3: Counter-Logik<\/span><\/i>[\/vc_column_text][divider line_type=&#8220;No Line&#8220; custom_height=&#8220;50&#8243;][vc_column_text css=&#8220;&#8220; text_direction=&#8220;default&#8220;]<span style=\"font-weight: 400;\">In F\u00e4llen, in denen wieder auf den urspr\u00fcnglichen Datensatz zur\u00fcckgewechselt wird, gilt dasselbe Verfahren: Der aktuell fehlende Wert wird durch den neuen Wert ausgeglichen, der erneut mit einem neuen LDTS eingef\u00fcgt wird. <\/span><\/p>\n<h2>Fazit<\/h2>\n<p><span style=\"font-weight: 400;\">Wir k\u00f6nnen daher festhalten, dass dieser Data-Vault-Ansatz gut f\u00fcr Tabellen funktioniert, die reine Hotspots f\u00fcr Messwerte bilden. Er eignet sich besonders dann, wenn \u00c4nderungen m\u00f6glich sind, obwohl die Daten Transaktionen darstellen, und kein CDC verf\u00fcgbar ist.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Anstelle einer Logik wie \u201eHole den aktuellsten Datensatz pro <a href=\"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/hash-keys-in-data-vault\/\">Hash-Key<\/a> (Driving Key)\u201c ist es m\u00f6glich, Berechnungen sowie Aggregationen direkt auf einer Tabelle auszuf\u00fchren. Das f\u00fchrt letztendlich zu einer besseren Performance in der Endstufe.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Wenn Sie noch Fragen haben, hinterlassen Sie gerne einen Kommentar. <\/span><span style=\"font-weight: 400;\">Wir freuen uns auf den Austausch und Ihre Gedanken zu diesem Thema.<\/span>[\/vc_column_text][\/vc_column][\/vc_row]\n","protected":false},"excerpt":{"rendered":"<p>[vc_row type=&#8220;in_container&#8220; full_screen_row_position=&#8220;middle&#8220; column_margin=&#8220;default&#8220; column_direction=&#8220;default&#8220; column_direction_tablet=&#8220;default&#8220; column_direction_phone=&#8220;default&#8220; scene_position=&#8220;center&#8220; text_color=&#8220;dark&#8220; text_align=&#8220;left&#8220; row_border_radius=&#8220;none&#8220; row_border_radius_applies=&#8220;bg&#8220; overflow=&#8220;visible&#8220; overlay_strength=&#8220;0.3&#8243; gradient_direction=&#8220;left_to_right&#8220; shape_divider_position=&#8220;bottom&#8220; bg_image_animation=&#8220;none&#8220;][vc_column column_padding=&#8220;no-extra-padding&#8220; column_padding_tablet=&#8220;inherit&#8220; column_padding_phone=&#8220;inherit&#8220; column_padding_position=&#8220;all&#8220; column_element_direction_desktop=&#8220;default&#8220; column_element_spacing=&#8220;default&#8220; desktop_text_alignment=&#8220;default&#8220; tablet_text_alignment=&#8220;default&#8220; phone_text_alignment=&#8220;default&#8220; background_color_opacity=&#8220;1&#8243; background_hover_color_opacity=&#8220;1&#8243; column_backdrop_filter=&#8220;none&#8220; column_shadow=&#8220;none&#8220;&#8230;<\/p>\n","protected":false},"author":91,"featured_media":60044,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3948],"tags":[],"class_list":["post-60042","post","type-post","status-publish","format-standard","has-post-thumbnail","category-data-vault"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO Pro 5.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"In diesem Artikel zeigen wir Ihnen, wie Sie Counter Records f\u00fcr den Umgang mit \u00c4nderungen und L\u00f6schungen in Data Vault 2.0 nutzen. Lesen Sie weiter, um mehr zu erfahren!\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Marc Winkelmann\"\/>\n\t<meta name=\"keywords\" content=\"data vault\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO Pro (AIOSEO) 5.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"de_DE\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Scalefree \u2013 Scalefree provides expert Data Vault solutions and certified training. Unlock your business\u2019s data potential with the global leaders in modern data warehousing.\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Ans\u00e4tze zur Handhabung von L\u00f6schungen und \u00c4nderungen in Data Vault 2.0\" \/>\n\t\t<meta property=\"og:description\" content=\"In diesem Artikel zeigen wir Ihnen, wie Sie Counter Records f\u00fcr den Umgang mit \u00c4nderungen und L\u00f6schungen in Data Vault 2.0 nutzen. Lesen Sie weiter, um mehr zu erfahren!\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/www.scalefree.com\/wp-content\/uploads\/2026\/04\/scalefree-facebook.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/www.scalefree.com\/wp-content\/uploads\/2026\/04\/scalefree-facebook.png\" \/>\n\t\t<meta property=\"og:image:width\" content=\"1640\" \/>\n\t\t<meta property=\"og:image:height\" content=\"856\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-01-28T07:53:52+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-08-13T10:12:42+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/datavault.scalefree\/\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@ScalefreeCOM\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Ans\u00e4tze zur Handhabung von L\u00f6schungen und \u00c4nderungen in Data Vault 2.0\" \/>\n\t\t<meta name=\"twitter:description\" content=\"In diesem Artikel zeigen wir Ihnen, wie Sie Counter Records f\u00fcr den Umgang mit \u00c4nderungen und L\u00f6schungen in Data Vault 2.0 nutzen. Lesen Sie weiter, um mehr zu erfahren!\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@ScalefreeCOM\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/www.scalefree.com\/wp-content\/uploads\/2026\/04\/scalefree-twitter-x.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/blog\\\/data-vault\\\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\\\/#article\",\"name\":\"Ans\\u00e4tze zur Handhabung von L\\u00f6schungen und \\u00c4nderungen in Data Vault 2.0\",\"headline\":\"Ans\\u00e4tze zur Handhabung von L\\u00f6schungen und \\u00c4nderungen in Data Vault 2.0\",\"author\":{\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/author\\\/mwinkelmann\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.scalefree.com\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/Figure-2-Insert-Logic.png\",\"width\":744,\"height\":847,\"caption\":\"Data Vault 2.0 - Insert logic\"},\"datePublished\":\"2020-01-28T08:53:52+01:00\",\"dateModified\":\"2026-08-13T12:12:42+02:00\",\"inLanguage\":\"de-DE\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/blog\\\/data-vault\\\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/blog\\\/data-vault\\\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\\\/#webpage\"},\"articleSection\":\"Data Vault, Optional\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/blog\\\/data-vault\\\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/#listItem\",\"position\":1,\"name\":\"Scalefree\",\"item\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/.\\\/blog\\\/#listItem\",\"name\":\"Blog\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/.\\\/blog\\\/#listItem\",\"position\":2,\"name\":\"Blog\",\"item\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/.\\\/blog\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/.\\\/blog\\\/data-vault\\\/#listItem\",\"name\":\"Data Vault\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/#listItem\",\"name\":\"Scalefree\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/.\\\/blog\\\/data-vault\\\/#listItem\",\"position\":3,\"name\":\"Data Vault\",\"item\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/.\\\/blog\\\/data-vault\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/blog\\\/data-vault\\\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\\\/#listItem\",\"name\":\"Ans\\u00e4tze zur Handhabung von L\\u00f6schungen und \\u00c4nderungen in Data Vault 2.0\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/.\\\/blog\\\/#listItem\",\"name\":\"Blog\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/blog\\\/data-vault\\\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\\\/#listItem\",\"position\":4,\"name\":\"Ans\\u00e4tze zur Handhabung von L\\u00f6schungen und \\u00c4nderungen in Data Vault 2.0\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/.\\\/blog\\\/data-vault\\\/#listItem\",\"name\":\"Data Vault\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/#organization\",\"name\":\"Scalefree\",\"description\":\"Scalefree provides expert Data Vault solutions and certified training. Unlock your business\\u2019s data potential with the global leaders in modern data warehousing.\",\"url\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/\",\"email\":\"contact@scalefree.com\",\"telephone\":\"+4951187989341\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":0,\"maxValue\":80},\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.scalefree.com\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/Scalefree.svg\",\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/blog\\\/data-vault\\\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\\\/#organizationLogo\",\"width\":240,\"height\":77,\"caption\":\"Scalefree Logo\"},\"image\":{\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/blog\\\/data-vault\\\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\\\/#organizationLogo\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/datavault.scalefree\\\/\",\"https:\\\/\\\/www.twitter.com\\\/ScalefreeCOM\",\"https:\\\/\\\/www.instagram.com\\\/scalefreeworks\\\/\",\"https:\\\/\\\/www.tiktok.com\\\/@scalefree\",\"https:\\\/\\\/www.youtube.com\\\/@scalefreeCOM\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/scalefree\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/author\\\/mwinkelmann\\\/#author\",\"url\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/author\\\/mwinkelmann\\\/\",\"name\":\"Marc Winkelmann\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/blog\\\/data-vault\\\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\\\/#webpage\",\"url\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/blog\\\/data-vault\\\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\\\/\",\"name\":\"Ans\\u00e4tze zur Handhabung von L\\u00f6schungen und \\u00c4nderungen in Data Vault 2.0\",\"description\":\"In diesem Artikel zeigen wir Ihnen, wie Sie Counter Records f\\u00fcr den Umgang mit \\u00c4nderungen und L\\u00f6schungen in Data Vault 2.0 nutzen. Lesen Sie weiter, um mehr zu erfahren!\",\"inLanguage\":\"de-DE\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/blog\\\/data-vault\\\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/author\\\/mwinkelmann\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/author\\\/mwinkelmann\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.scalefree.com\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/Figure-2-Insert-Logic.png\",\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/blog\\\/data-vault\\\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\\\/#mainImage\",\"width\":744,\"height\":847,\"caption\":\"Data Vault 2.0 - Insert logic\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/blog\\\/data-vault\\\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\\\/#mainImage\"},\"datePublished\":\"2020-01-28T08:53:52+01:00\",\"dateModified\":\"2026-08-13T12:12:42+02:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/#website\",\"url\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/\",\"name\":\"Scalefree\",\"alternateName\":\"Scalefree\",\"description\":\"Scalefree provides expert Data Vault solutions and certified training. Unlock your business\\u2019s data potential with the global leaders in modern data warehousing.\",\"inLanguage\":\"de-DE\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.scalefree.com\\\/de\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO Pro -->\r\n\t\t<title>Ans\u00e4tze zur Handhabung von L\u00f6schungen und \u00c4nderungen in Data Vault 2.0<\/title>\n\n","aioseo_head_json":{"title":"Ans\u00e4tze zur Handhabung von L\u00f6schungen und \u00c4nderungen in Data Vault 2.0","description":"In diesem Artikel zeigen wir Ihnen, wie Sie Counter Records f\u00fcr den Umgang mit \u00c4nderungen und L\u00f6schungen in Data Vault 2.0 nutzen. Lesen Sie weiter, um mehr zu erfahren!","canonical_url":"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\/","robots":"max-image-preview:large","keywords":"data vault","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\/#article","name":"Ans\u00e4tze zur Handhabung von L\u00f6schungen und \u00c4nderungen in Data Vault 2.0","headline":"Ans\u00e4tze zur Handhabung von L\u00f6schungen und \u00c4nderungen in Data Vault 2.0","author":{"@id":"https:\/\/www.scalefree.com\/de\/author\/mwinkelmann\/#author"},"publisher":{"@id":"https:\/\/www.scalefree.com\/de\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/01\/Figure-2-Insert-Logic.png","width":744,"height":847,"caption":"Data Vault 2.0 - Insert logic"},"datePublished":"2020-01-28T08:53:52+01:00","dateModified":"2026-08-13T12:12:42+02:00","inLanguage":"de-DE","mainEntityOfPage":{"@id":"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\/#webpage"},"isPartOf":{"@id":"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\/#webpage"},"articleSection":"Data Vault, Optional"},{"@type":"BreadcrumbList","@id":"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.scalefree.com\/de\/#listItem","position":1,"name":"Scalefree","item":"https:\/\/www.scalefree.com\/de\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.scalefree.com\/de\/.\/blog\/#listItem","name":"Blog"}},{"@type":"ListItem","@id":"https:\/\/www.scalefree.com\/de\/.\/blog\/#listItem","position":2,"name":"Blog","item":"https:\/\/www.scalefree.com\/de\/.\/blog\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.scalefree.com\/de\/.\/blog\/data-vault\/#listItem","name":"Data Vault"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.scalefree.com\/de\/#listItem","name":"Scalefree"}},{"@type":"ListItem","@id":"https:\/\/www.scalefree.com\/de\/.\/blog\/data-vault\/#listItem","position":3,"name":"Data Vault","item":"https:\/\/www.scalefree.com\/de\/.\/blog\/data-vault\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\/#listItem","name":"Ans\u00e4tze zur Handhabung von L\u00f6schungen und \u00c4nderungen in Data Vault 2.0"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.scalefree.com\/de\/.\/blog\/#listItem","name":"Blog"}},{"@type":"ListItem","@id":"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\/#listItem","position":4,"name":"Ans\u00e4tze zur Handhabung von L\u00f6schungen und \u00c4nderungen in Data Vault 2.0","previousItem":{"@type":"ListItem","@id":"https:\/\/www.scalefree.com\/de\/.\/blog\/data-vault\/#listItem","name":"Data Vault"}}]},{"@type":"Organization","@id":"https:\/\/www.scalefree.com\/de\/#organization","name":"Scalefree","description":"Scalefree provides expert Data Vault solutions and certified training. Unlock your business\u2019s data potential with the global leaders in modern data warehousing.","url":"https:\/\/www.scalefree.com\/de\/","email":"contact@scalefree.com","telephone":"+4951187989341","numberOfEmployees":{"@type":"QuantitativeValue","minValue":0,"maxValue":80},"logo":{"@type":"ImageObject","url":"https:\/\/www.scalefree.com\/wp-content\/uploads\/2025\/07\/Scalefree.svg","@id":"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\/#organizationLogo","width":240,"height":77,"caption":"Scalefree Logo"},"image":{"@id":"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\/#organizationLogo"},"sameAs":["https:\/\/www.facebook.com\/datavault.scalefree\/","https:\/\/www.twitter.com\/ScalefreeCOM","https:\/\/www.instagram.com\/scalefreeworks\/","https:\/\/www.tiktok.com\/@scalefree","https:\/\/www.youtube.com\/@scalefreeCOM","https:\/\/www.linkedin.com\/company\/scalefree\/"]},{"@type":"Person","@id":"https:\/\/www.scalefree.com\/de\/author\/mwinkelmann\/#author","url":"https:\/\/www.scalefree.com\/de\/author\/mwinkelmann\/","name":"Marc Winkelmann"},{"@type":"WebPage","@id":"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\/#webpage","url":"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\/","name":"Ans\u00e4tze zur Handhabung von L\u00f6schungen und \u00c4nderungen in Data Vault 2.0","description":"In diesem Artikel zeigen wir Ihnen, wie Sie Counter Records f\u00fcr den Umgang mit \u00c4nderungen und L\u00f6schungen in Data Vault 2.0 nutzen. Lesen Sie weiter, um mehr zu erfahren!","inLanguage":"de-DE","isPartOf":{"@id":"https:\/\/www.scalefree.com\/de\/#website"},"breadcrumb":{"@id":"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\/#breadcrumblist"},"author":{"@id":"https:\/\/www.scalefree.com\/de\/author\/mwinkelmann\/#author"},"creator":{"@id":"https:\/\/www.scalefree.com\/de\/author\/mwinkelmann\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/www.scalefree.com\/wp-content\/uploads\/2020\/01\/Figure-2-Insert-Logic.png","@id":"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\/#mainImage","width":744,"height":847,"caption":"Data Vault 2.0 - Insert logic"},"primaryImageOfPage":{"@id":"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\/#mainImage"},"datePublished":"2020-01-28T08:53:52+01:00","dateModified":"2026-08-13T12:12:42+02:00"},{"@type":"WebSite","@id":"https:\/\/www.scalefree.com\/de\/#website","url":"https:\/\/www.scalefree.com\/de\/","name":"Scalefree","alternateName":"Scalefree","description":"Scalefree provides expert Data Vault solutions and certified training. Unlock your business\u2019s data potential with the global leaders in modern data warehousing.","inLanguage":"de-DE","publisher":{"@id":"https:\/\/www.scalefree.com\/de\/#organization"}}]},"og:locale":"de_DE","og:site_name":"Scalefree \u2013 Scalefree provides expert Data Vault solutions and certified training. Unlock your business\u2019s data potential with the global leaders in modern data warehousing.","og:type":"article","og:title":"Ans\u00e4tze zur Handhabung von L\u00f6schungen und \u00c4nderungen in Data Vault 2.0","og:description":"In diesem Artikel zeigen wir Ihnen, wie Sie Counter Records f\u00fcr den Umgang mit \u00c4nderungen und L\u00f6schungen in Data Vault 2.0 nutzen. Lesen Sie weiter, um mehr zu erfahren!","og:url":"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\/","og:image":"https:\/\/www.scalefree.com\/wp-content\/uploads\/2026\/04\/scalefree-facebook.png","og:image:secure_url":"https:\/\/www.scalefree.com\/wp-content\/uploads\/2026\/04\/scalefree-facebook.png","og:image:width":1640,"og:image:height":856,"article:published_time":"2020-01-28T07:53:52+00:00","article:modified_time":"2026-08-13T10:12:42+00:00","article:publisher":"https:\/\/www.facebook.com\/datavault.scalefree\/","twitter:card":"summary","twitter:site":"@ScalefreeCOM","twitter:title":"Ans\u00e4tze zur Handhabung von L\u00f6schungen und \u00c4nderungen in Data Vault 2.0","twitter:description":"In diesem Artikel zeigen wir Ihnen, wie Sie Counter Records f\u00fcr den Umgang mit \u00c4nderungen und L\u00f6schungen in Data Vault 2.0 nutzen. Lesen Sie weiter, um mehr zu erfahren!","twitter:creator":"@ScalefreeCOM","twitter:image":"https:\/\/www.scalefree.com\/wp-content\/uploads\/2026\/04\/scalefree-twitter-x.png"},"aioseo_meta_data":{"post_id":"60042","title":"Ans\u00e4tze zur Handhabung von L\u00f6schungen und \u00c4nderungen in Data Vault 2.0","description":"In diesem Artikel zeigen wir Ihnen, wie Sie Counter Records f\u00fcr den Umgang mit \u00c4nderungen und L\u00f6schungen in Data Vault 2.0 nutzen. Lesen Sie weiter, um mehr zu erfahren! ","keywords":null,"keyphrases":{"focus":{"keyphrase":"data vault 2.0","score":87},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":"{\"article\":{\"articleType\":\"BlogPosting\"},\"course\":{\"name\":\"\",\"description\":\"\",\"provider\":\"\"},\"faq\":{\"pages\":[]},\"product\":{\"reviews\":[]},\"recipe\":{\"ingredients\":[],\"instructions\":[],\"keywords\":[]},\"software\":{\"reviews\":[],\"operatingSystems\":[]},\"webPage\":{\"webPageType\":\"WebPage\"}}","pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"seo_analyzer_scan_date":"2026-05-11 10:07:40","breadcrumb_settings":null,"limit_modified_date":false,"open_ai":"{\"title\":{\"suggestions\":[],\"usage\":0},\"description\":{\"suggestions\":[],\"usage\":0}}","ai":{"faqs":[],"keyPoints":[],"schemas":[],"titles":[],"descriptions":[],"socialPosts":{"email":[],"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2026-08-13 10:12:41","updated":"2026-08-14 07:40:41","focus_keyword":"data vault 2.0","additional_keywords":null,"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t<a href=\"https:\/\/www.scalefree.com\/de\/\" title=\"Scalefree\">Scalefree<\/a>\n<\/span><span class=\"aioseo-breadcrumb-separator\">\u2014<\/span><span class=\"aioseo-breadcrumb\">\n\t<a href=\"https:\/\/www.scalefree.com\/de\/.\/blog\/\" title=\"Blog\">Blog<\/a>\n<\/span><span class=\"aioseo-breadcrumb-separator\">\u2014<\/span><span class=\"aioseo-breadcrumb\">\n\t<a href=\"https:\/\/www.scalefree.com\/de\/.\/blog\/data-vault\/\" title=\"Data Vault\">Data Vault<\/a>\n<\/span><span class=\"aioseo-breadcrumb-separator\">\u2014<\/span><span class=\"aioseo-breadcrumb\">\n\tAns\u00e4tze zur Handhabung von L\u00f6schungen und \u00c4nderungen in Data Vault 2.0\n<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Scalefree","link":"https:\/\/www.scalefree.com\/de\/"},{"label":"Blog","link":"https:\/\/www.scalefree.com\/de\/.\/blog\/"},{"label":"Data Vault","link":"https:\/\/www.scalefree.com\/de\/.\/blog\/data-vault\/"},{"label":"Ans\u00e4tze zur Handhabung von L\u00f6schungen und \u00c4nderungen in Data Vault 2.0","link":"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/ansaetze-zur-handhabung-von-loeschungen-und-aenderungen-in-data-vault-2-0\/"}],"_links":{"self":[{"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/posts\/60042","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/users\/91"}],"replies":[{"embeddable":true,"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/comments?post=60042"}],"version-history":[{"count":0,"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/posts\/60042\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/media\/60044"}],"wp:attachment":[{"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/media?parent=60042"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/categories?post=60042"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/tags?post=60042"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}