{"id":2843,"date":"2022-05-24T15:55:52","date_gmt":"2022-05-24T13:55:52","guid":{"rendered":"https:\/\/devbloomppm.wpengine.com\/?p=2843"},"modified":"2022-06-01T11:53:21","modified_gmt":"2022-06-01T09:53:21","slug":"audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5","status":"publish","type":"post","link":"https:\/\/bloomppm.com\/fr\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\/","title":{"rendered":"Audit de donn\u00e9es :\u00a0v\u00e9rifier l\u2019absence de doublons (ONB identiques) dans chaque table P5"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"2843\" class=\"elementor elementor-2843\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-725e085 elementor-section-stretched elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"725e085\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-78dadd8\" data-id=\"78dadd8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-7a06bdb\" data-id=\"7a06bdb\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b6c83ad elementor-widget elementor-widget-heading\" data-id=\"b6c83ad\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Audit de donn\u00e9es : v\u00e9rifier l\u2019absence de doublons (ONB identiques) dans chaque table P5<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-22f5647 elementor-section-stretched elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"22f5647\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-4706b90\" data-id=\"4706b90\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d8a3fd1 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"d8a3fd1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c858b96 elementor-widget elementor-widget-heading\" data-id=\"c858b96\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h5 class=\"elementor-heading-title elementor-size-default\">Sommaire<\/h5>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7c52820 elementor-align-start elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"7c52820\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"#title1\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-chevron-right\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Description<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"#title2\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-chevron-right\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Requ\u00eates SQL<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-e69c542\" data-id=\"e69c542\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b2c4aed elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"b2c4aed\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fb764c9 elementor-widget elementor-widget-heading\" data-id=\"fb764c9\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"title1\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Description<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7c1997c elementor-widget elementor-widget-text-editor\" data-id=\"7c1997c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Dans certains cas, lorsque l\u2019on n\u2019a pas positionn\u00e9 d\u2019offset pour les bases de donn\u00e9es Planisware par exemple, il peut arriver que l\u2019on constate la pr\u00e9sence d\u2019objets ayant le m\u00eame ONB dans une m\u00eame table Planisware. Ceci est une grave corruption du mod\u00e8le de donn\u00e9es, car Planisware ne sera pas en mesure de charger les 2 objets. Il en chargera un seul sur les 2 et la plupart du temps remontera une erreur indiquant que l\u2019objet xxxx poss\u00e8dant le m\u00eame ONB que l\u2019objet yyyy n\u2019a pu \u00eatre charg\u00e9.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b0956d7 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"b0956d7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-74cdd93 elementor-widget elementor-widget-heading\" data-id=\"74cdd93\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"title2\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Requ\u00eates SQL<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c78c4d9 elementor-widget elementor-widget-text-editor\" data-id=\"c78c4d9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Il est possible de v\u00e9rifier la pr\u00e9sence de tels doublons par la m\u00e9thode suivante.<\/p><p>Pour commencer il faut r\u00e9cup\u00e9rer la liste des tables Planisware poss\u00e9dant une colonne \u00ab ONB \u00bb. ( <strong>Cf. Requ\u00eate SQL pour avoir toutes les tables de la BDD avec poss\u00e9dant un champ \u00ab ONB \u00bb<\/strong>).<\/p><p>Ensuite, r\u00e9cup\u00e9rer cette liste de tables dans Excel pour g\u00e9n\u00e9rer une requ\u00eate globale du type :<\/p><p><span style=\"color: #993366;\">(SELECT ONB, Count(*),\u2019TABLE_PLW_1\u2019 FROM TABLE_PLW_1\u00a0<\/span><\/p><p><span style=\"color: #993366;\">GROUP BY ONB HAVING Count(*) &gt; 1) UNION<\/span><\/p><p><span style=\"color: #993366;\">(SELECT ONB, Count(*),\u2019TABLE_PLW_2\u2019 FROM TABLE_PLW_2<\/span><\/p><p><span style=\"color: #993366;\">GROUP BY ONB HAVING Count(*) &gt; 1) UNION<\/span><\/p><p><span style=\"color: #993366;\">&#8230;<\/span><\/p><p><span style=\"color: #993366;\">(SELECT ONB, Count(*),\u2019TABLE_PLW_N\u2019 FROM TABLE_PLW_N<\/span><\/p><p><span style=\"color: #993366;\">GROUP BY ONB HAVING Count(*) &gt; 1) ;<\/span><\/p><p>R\u00e9sultat obtenu :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f5cd345 elementor-widget elementor-widget-image\" data-id=\"f5cd345\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"597\" height=\"233\" src=\"https:\/\/bloomppm.com\/wp-content\/uploads\/2022\/05\/audit_de_donnes_verifier_abscence_de_doublons_dans_chaque_table_P5_image_1.jpg\" class=\"attachment-medium_large size-medium_large wp-image-2848\" alt=\"audit_de_donnes_verifier_abscence_de_doublons_dans_chaque_table_P5_image_1\" srcset=\"https:\/\/bloomppm.com\/wp-content\/uploads\/2022\/05\/audit_de_donnes_verifier_abscence_de_doublons_dans_chaque_table_P5_image_1.jpg 597w, https:\/\/bloomppm.com\/wp-content\/uploads\/2022\/05\/audit_de_donnes_verifier_abscence_de_doublons_dans_chaque_table_P5_image_1-300x117.jpg 300w\" sizes=\"(max-width: 597px) 100vw, 597px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e82b3da elementor-widget elementor-widget-text-editor\" data-id=\"e82b3da\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>R\u00e9sultat de la requ\u00eate permettant de remonter les doublons.<\/p><p>Ainsi ici on constate que l\u2019on a des doublons dans les tables suivantes :<\/p><p style=\"padding-left: 40px;\">\u2192<strong>COMMON_DATASET<\/strong><\/p><p style=\"padding-left: 40px;\">\u2192<strong>TASK<\/strong><\/p><p>Dans les 2 tables, il y a 2 objets qui poss\u00e8dent le m\u00eame ONB : le champ count(*) est \u00e9gal \u00e0 2 pour chacune des tables.<\/p><p>Dans ce cas on a remont\u00e9 les doublons pr\u00e9sents dans une m\u00eame table ce qui est le cas le plus critique pour Planisware.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Audit de donn\u00e9es : v\u00e9rifier l\u2019absence de doublons (ONB identiques) dans chaque table P5 Sommaire Description Requ\u00eates SQL Description Dans certains cas, lorsque l\u2019on n\u2019a pas positionn\u00e9 d\u2019offset pour les bases de donn\u00e9es Planisware par exemple, il peut arriver que l\u2019on constate la pr\u00e9sence d\u2019objets ayant le m\u00eame ONB dans une m\u00eame table Planisware. Ceci&hellip;&nbsp;<a href=\"https:\/\/bloomppm.com\/fr\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\/\" rel=\"bookmark\">Lire la suite &raquo;<span class=\"screen-reader-text\">Audit de donn\u00e9es :\u00a0v\u00e9rifier l\u2019absence de doublons (ONB identiques) dans chaque table P5<\/span><\/a><\/p>\n","protected":false},"author":9,"featured_media":2848,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"left","neve_meta_author_avatar":"","neve_post_elements_order":"[\"meta\",\"thumbnail\",\"content\",\"tags\",\"comments\"]","neve_meta_disable_header":"off","neve_meta_disable_footer":"","neve_meta_disable_title":"","_themeisle_gutenberg_block_has_review":false,"cybocfi_hide_featured_image":"yes","footnotes":""},"categories":[9],"tags":[],"class_list":["post-2843","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-non-classifiee"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.9 (Yoast SEO v27.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Audit de donn\u00e9es :\u00a0v\u00e9rifier l\u2019absence de doublons (ONB identiques) dans chaque table P5 - BLOOM PPM<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bloomppm.com\/fr\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\/\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\\\/\"},\"author\":{\"name\":\"Alice Coscia\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#\\\/schema\\\/person\\\/70bfd279f3e18f0eecfa256931542f72\"},\"headline\":\"Audit de donn\u00e9es :\u00a0v\u00e9rifier l\u2019absence de doublons (ONB identiques) dans chaque table P5\",\"datePublished\":\"2022-05-24T13:55:52+00:00\",\"dateModified\":\"2022-06-01T09:53:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\\\/\"},\"wordCount\":340,\"publisher\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/bloomppm.com\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/audit_de_donnes_verifier_abscence_de_doublons_dans_chaque_table_P5_image_1.jpg\",\"articleSection\":[\"Non classifi\u00e9(e)\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\\\/\",\"url\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\\\/\",\"name\":\"Audit de donn\u00e9es :\u00a0v\u00e9rifier l\u2019absence de doublons (ONB identiques) dans chaque table P5 - BLOOM PPM\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/bloomppm.com\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/audit_de_donnes_verifier_abscence_de_doublons_dans_chaque_table_P5_image_1.jpg\",\"datePublished\":\"2022-05-24T13:55:52+00:00\",\"dateModified\":\"2022-06-01T09:53:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/bloomppm.com\\\/fr\\\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Audit de donn\u00e9es :\u00a0v\u00e9rifier l\u2019absence de doublons (ONB identiques) dans chaque table P5\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#website\",\"url\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/\",\"name\":\"BLOOM PPM\",\"description\":\"We make your projects grow\",\"publisher\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#organization\",\"name\":\"Bloom PPM\",\"url\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/bloomppm.com\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/Blue_without_background.png\",\"contentUrl\":\"https:\\\/\\\/bloomppm.com\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/Blue_without_background.png\",\"width\":602,\"height\":204,\"caption\":\"Bloom PPM\"},\"image\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/bloomppm\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#\\\/schema\\\/person\\\/70bfd279f3e18f0eecfa256931542f72\",\"name\":\"Alice Coscia\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/78e17445df21b4802dbcd0ad4f4999611564d6f76fa19ec43b21aed20cb99a21?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/78e17445df21b4802dbcd0ad4f4999611564d6f76fa19ec43b21aed20cb99a21?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/78e17445df21b4802dbcd0ad4f4999611564d6f76fa19ec43b21aed20cb99a21?s=96&d=mm&r=g\",\"caption\":\"Alice Coscia\"},\"url\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/author\\\/alice-cosciabloomppm-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Audit de donn\u00e9es :\u00a0v\u00e9rifier l\u2019absence de doublons (ONB identiques) dans chaque table P5 - BLOOM PPM","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/bloomppm.com\/fr\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\/","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/bloomppm.com\/fr\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\/#article","isPartOf":{"@id":"https:\/\/bloomppm.com\/fr\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\/"},"author":{"name":"Alice Coscia","@id":"https:\/\/bloomppm.com\/fr\/#\/schema\/person\/70bfd279f3e18f0eecfa256931542f72"},"headline":"Audit de donn\u00e9es :\u00a0v\u00e9rifier l\u2019absence de doublons (ONB identiques) dans chaque table P5","datePublished":"2022-05-24T13:55:52+00:00","dateModified":"2022-06-01T09:53:21+00:00","mainEntityOfPage":{"@id":"https:\/\/bloomppm.com\/fr\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\/"},"wordCount":340,"publisher":{"@id":"https:\/\/bloomppm.com\/fr\/#organization"},"image":{"@id":"https:\/\/bloomppm.com\/fr\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\/#primaryimage"},"thumbnailUrl":"https:\/\/bloomppm.com\/wp-content\/uploads\/2022\/05\/audit_de_donnes_verifier_abscence_de_doublons_dans_chaque_table_P5_image_1.jpg","articleSection":["Non classifi\u00e9(e)"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/bloomppm.com\/fr\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\/","url":"https:\/\/bloomppm.com\/fr\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\/","name":"Audit de donn\u00e9es :\u00a0v\u00e9rifier l\u2019absence de doublons (ONB identiques) dans chaque table P5 - BLOOM PPM","isPartOf":{"@id":"https:\/\/bloomppm.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bloomppm.com\/fr\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\/#primaryimage"},"image":{"@id":"https:\/\/bloomppm.com\/fr\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\/#primaryimage"},"thumbnailUrl":"https:\/\/bloomppm.com\/wp-content\/uploads\/2022\/05\/audit_de_donnes_verifier_abscence_de_doublons_dans_chaque_table_P5_image_1.jpg","datePublished":"2022-05-24T13:55:52+00:00","dateModified":"2022-06-01T09:53:21+00:00","breadcrumb":{"@id":"https:\/\/bloomppm.com\/fr\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bloomppm.com\/fr\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/bloomppm.com\/fr\/audit-de-donnees-verifier-labsence-de-doublons-onb-identiques-dans-chaque-table-p5\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bloomppm.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Audit de donn\u00e9es :\u00a0v\u00e9rifier l\u2019absence de doublons (ONB identiques) dans chaque table P5"}]},{"@type":"WebSite","@id":"https:\/\/bloomppm.com\/fr\/#website","url":"https:\/\/bloomppm.com\/fr\/","name":"BLOOM PPM","description":"We make your projects grow","publisher":{"@id":"https:\/\/bloomppm.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bloomppm.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/bloomppm.com\/fr\/#organization","name":"Bloom PPM","url":"https:\/\/bloomppm.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/bloomppm.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/bloomppm.com\/wp-content\/uploads\/2020\/10\/Blue_without_background.png","contentUrl":"https:\/\/bloomppm.com\/wp-content\/uploads\/2020\/10\/Blue_without_background.png","width":602,"height":204,"caption":"Bloom PPM"},"image":{"@id":"https:\/\/bloomppm.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/bloomppm\/"]},{"@type":"Person","@id":"https:\/\/bloomppm.com\/fr\/#\/schema\/person\/70bfd279f3e18f0eecfa256931542f72","name":"Alice Coscia","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/78e17445df21b4802dbcd0ad4f4999611564d6f76fa19ec43b21aed20cb99a21?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/78e17445df21b4802dbcd0ad4f4999611564d6f76fa19ec43b21aed20cb99a21?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/78e17445df21b4802dbcd0ad4f4999611564d6f76fa19ec43b21aed20cb99a21?s=96&d=mm&r=g","caption":"Alice Coscia"},"url":"https:\/\/bloomppm.com\/fr\/author\/alice-cosciabloomppm-com\/"}]}},"_links":{"self":[{"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/posts\/2843","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/comments?post=2843"}],"version-history":[{"count":0,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/posts\/2843\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/media\/2848"}],"wp:attachment":[{"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/media?parent=2843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/categories?post=2843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/tags?post=2843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}