{"id":1580,"date":"2015-06-21T20:12:06","date_gmt":"2015-06-21T23:12:06","guid":{"rendered":"http:\/\/dev.dbarj.com.br\/?p=1580"},"modified":"2015-06-21T20:12:06","modified_gmt":"2015-06-21T23:12:06","slug":"ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query","status":"publish","type":"post","link":"https:\/\/dev.dbarj.com.br\/en\/2015\/06\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\/","title":{"rendered":"OCM 11g Preparation &#8211; Configure a schema to support a star transformation query"},"content":{"rendered":"<p>Star transformation can be really useful in DW environments, where you have your tables divide into dimensions and facts. And the most important, you need to have bitmap indexes!<\/p>\n<p>To implement it, you need to change the star_transformation_enabled for your user session and create the tables and indexes to play.<\/p>\n<p>Try to\u00a0practice creating one fact table and 3 dimensions. Later, create a bitmap join and check the plans with the three compatible values for <strong><em>STAR_TRANSFORMATION_ENABLED = { FALSE | TRUE | TEMP_DISABLE }<\/em><\/strong>.<\/p>\n<p><strong>Path to Documentation<\/strong>:<\/p>\n<p><span style=\"color: #800000;\">Data Warehousing Guide -&gt; 20 Schema Modeling Techniques<br \/>\nData Warehousing Guide -&gt; 7 Indexes<\/span><\/p>\n<br>\r\nClick here to go back to the <a title=\"OCM 11g Preparation\" href=\"\/?page_id=923\">Main OCM 11g Preparation<\/a> page.\r\n<br><br>\r\nHave you enjoyed? Please leave a comment or give a ?!\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-1580 jlk' href='javascript:void(0)' data-task='like' data-post_id='1580' data-nonce='b7aaf4ff99' rel='nofollow'><img class='wti-pixel' src='https:\/\/dev.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-1580 lc'>+2<\/span><\/a><\/div><\/div> <div class='status-1580 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Star transformation can be really useful in DW environments, where you have your tables divide into dimensions and facts. And the most important, you need to have bitmap indexes! To implement it, you need to change the star_transformation_enabled for your user session and create the tables and indexes to play. Try to\u00a0practice creating one fact &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/dev.dbarj.com.br\/en\/2015\/06\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[],"class_list":["post-1580","post","type-post","status-publish","format-standard","hentry","category-ocm11g-en","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>OCM 11g Preparation - Configure a schema to support a star transformation query - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"Configure a schema to support a star transformation query for Oracle OCM 11g Certification\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dev.dbarj.com.br\/en\/2015\/06\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2015\\\/06\\\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2015\\\/06\\\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"OCM 11g Preparation &#8211; Configure a schema to support a star transformation query\",\"datePublished\":\"2015-06-21T23:12:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2015\\\/06\\\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\\\/\"},\"wordCount\":117,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"articleSection\":[\"OCM 11g Preparation\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2015\\\/06\\\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2015\\\/06\\\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\\\/\",\"url\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2015\\\/06\\\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\\\/\",\"name\":\"OCM 11g Preparation - Configure a schema to support a star transformation query - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#website\"},\"datePublished\":\"2015-06-21T23:12:06+00:00\",\"description\":\"Configure a schema to support a star transformation query for Oracle OCM 11g Certification\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2015\\\/06\\\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2015\\\/06\\\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2015\\\/06\\\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"OCM 11g Preparation - Configure a schema to support a star transformation query\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"OCM 11g Preparation - Configure a schema to support a star transformation query - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Configure a schema to support a star transformation query for Oracle OCM 11g Certification","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:\/\/dev.dbarj.com.br\/en\/2015\/06\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dev.dbarj.com.br\/en\/2015\/06\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\/#article","isPartOf":{"@id":"https:\/\/dev.dbarj.com.br\/en\/2015\/06\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\/"},"author":{"name":"DBA RJ","@id":"https:\/\/dev.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"OCM 11g Preparation &#8211; Configure a schema to support a star transformation query","datePublished":"2015-06-21T23:12:06+00:00","mainEntityOfPage":{"@id":"https:\/\/dev.dbarj.com.br\/en\/2015\/06\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\/"},"wordCount":117,"commentCount":0,"publisher":{"@id":"https:\/\/dev.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"articleSection":["OCM 11g Preparation"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dev.dbarj.com.br\/en\/2015\/06\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dev.dbarj.com.br\/en\/2015\/06\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\/","url":"https:\/\/dev.dbarj.com.br\/en\/2015\/06\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\/","name":"OCM 11g Preparation - Configure a schema to support a star transformation query - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/dev.dbarj.com.br\/en\/#website"},"datePublished":"2015-06-21T23:12:06+00:00","description":"Configure a schema to support a star transformation query for Oracle OCM 11g Certification","breadcrumb":{"@id":"https:\/\/dev.dbarj.com.br\/en\/2015\/06\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dev.dbarj.com.br\/en\/2015\/06\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dev.dbarj.com.br\/en\/2015\/06\/ocm-11g-preparation-configure-a-schema-to-support-a-star-transformation-query\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dev.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"OCM 11g Preparation - Configure a schema to support a star transformation query"}]},{"@type":"WebSite","@id":"https:\/\/dev.dbarj.com.br\/en\/#website","url":"https:\/\/dev.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/dev.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dev.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/dev.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/1580","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=1580"}],"version-history":[{"count":0,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/1580\/revisions"}],"wp:attachment":[{"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=1580"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=1580"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=1580"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}