{"id":14433,"date":"2022-11-18T19:23:00","date_gmt":"2022-11-18T13:53:00","guid":{"rendered":"https:\/\/www.interviewbit.com\/blog\/?post_type=web-story&#038;p=14433"},"modified":"2022-11-18T19:23:02","modified_gmt":"2022-11-18T13:53:02","slug":"data-warehouse-components","status":"publish","type":"web-story","link":"https:\/\/www.interviewbit.com\/blog\/web-stories\/data-warehouse-components\/","title":{"rendered":"Data Warehouse Components"},"content":{"rendered":"<p><html amp=\"\" lang=\"en\"><head><meta charSet=\"utf-8\"\/><meta name=\"viewport\" content=\"width=device-width,minimum-scale=1,initial-scale=1\"\/><script async=\"\" src=\"https:\/\/cdn.ampproject.org\/v0.js\"><\/script><script async=\"\" src=\"https:\/\/cdn.ampproject.org\/v0\/amp-story-1.0.js\" custom-element=\"amp-story\"><\/script><link href=\"https:\/\/fonts.googleapis.com\/css2?display=swap&amp;family=Oranienbaum&amp;family=Roboto%3Awght%40400%3B700&amp;family=Darker+Grotesque%3Awght%40400%3B700&amp;family=Poppins%3Awght%40400%3B700\" rel=\"stylesheet\"\/><link href=\"https:\/\/images.unsplash.com\/photo-1581087724844-037b13e16b0b?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=6630&amp;h=9940&amp;fit=max\" rel=\"preload\" as=\"image\"\/>\n<style amp-boilerplate=\"\">body{-webkit-animation:-amp-start 8s steps(1,end) 0s 1 normal both;-moz-animation:-amp-start 8s steps(1,end) 0s 1 normal both;-ms-animation:-amp-start 8s steps(1,end) 0s 1 normal both;animation:-amp-start 8s steps(1,end) 0s 1 normal both}@-webkit-keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}@-moz-keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}@-ms-keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}@-o-keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}@keyframes -amp-start{from{visibility:hidden}to{visibility:visible}}<\/style>\n<p><noscript><\/p>\n<style amp-boilerplate=\"\">body{-webkit-animation:none;-moz-animation:none;-ms-animation:none;animation:none}<\/style>\n<p><\/noscript><\/p>\n<style amp-custom=\"\">\n              h1, h2, h3 { font-weight: normal; }<\/p>\n<p>              amp-story-page {\n                background-color: #131516;\n              }<\/p>\n<p>              amp-story-grid-layer {\n                overflow: visible;\n              }<\/p>\n<p>              @media (max-aspect-ratio: 9 \/ 16)  {\n                @media (min-aspect-ratio: 320 \/ 678) {\n                  amp-story-grid-layer.grid-layer {\n                    margin-top: calc((100% \/ 0.5625 - 100% \/ 0.6666666666666666) \/ 2);\n                  }\n                }\n              }<\/p>\n<p>              @media not all and (min-resolution:.001dpcm) {\n                @media {\n                  p.text-wrapper > span {\n                    font-size: calc(100% - 0.5px);\n                  }\n                }\n              }<\/p>\n<p>              .page-fullbleed-area,\n              .page-background-overlay-area {\n                position: absolute;\n                overflow: hidden;\n                width: 100%;\n                left: 0;\n                height: calc(1.1851851851851851 * 100%);\n                top: calc((1 - 1.1851851851851851) * 100% \/ 2);\n              }<\/p>\n<p>              .element-overlay-area {\n                position: absolute;\n                width: 100%;\n                height: 100%;\n                top: 0;\n                left: 0;\n              }<\/p>\n<p>              .page-safe-area {\n                overflow: visible;\n                position: absolute;\n                top: 0;\n                bottom: 0;\n                left: 0;\n                right: 0;\n                width: 100%;\n                height: calc(0.84375 * 100%);\n                margin: auto 0;\n              }<\/p>\n<p>              .mask {\n                position: absolute;\n                overflow: hidden;\n              }<\/p>\n<p>              .fill {\n                position: absolute;\n                top: 0;\n                left: 0;\n                right: 0;\n                bottom: 0;\n                margin: 0;\n              }<\/p>\n<p>              @media (prefers-reduced-motion: no-preference) {\n                .animation-wrapper {\n                  opacity: var(--initial-opacity);\n                  transform: var(--initial-transform);\n                }\n              }<\/p>\n<p>              amp-story-grid-layer.align-bottom {\n                align-content: end;\n                padding: 0;\n              }<\/p>\n<p>              .captions-area {\n                padding: 0 32px 0;\n              }<\/p>\n<p>              amp-story-captions {\n                margin-bottom: 16px;\n                text-align: center;\n              }<\/p>\n<p>              amp-story-captions span {\n                display: inline-block;\n                margin: 0;\n                padding: 6px 12px;\n                vertical-align: middle;\n                border-radius: 15px;\n                background: rgba(11, 11, 11, 0.6);\n                color: rgba(255, 255, 255, 1);\n                font-family: -apple-system, BlinkMacSystemFont, \"Segoe UI\", Roboto, Oxygen-Sans, Ubuntu, Cantarell, \"Helvetica Neue\", sans-serif;;\n                font-size: calc(4 * var(--story-page-vw));\n                line-height: 1.4;\n                word-break: break-word;\n                word-wrap: break-word;\n                overflow-wrap: break-word;\n              }\n              <\/style>\n<p><meta name=\"web-stories-replace-head-start\"\/><title>Data Warehouse Components<\/title><link rel=\"canonical\" href=\"https:\/\/www.interviewbit.com\/blog\/?post_type=web-story&amp;p=14433\"\/><meta name=\"web-stories-replace-head-end\"\/><\/head><body><amp-story standalone=\"\" publisher=\"InterviewBit\" publisher-logo-src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/cropped-tumblr-logo.png\" title=\"Data Warehouse Components\" poster-portrait-src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/11\/cropped-Components-of-Data-Warehouse.png\"><amp-story-page id=\"039bee5f-dd9a-4634-90e1-781b45874a59\" auto-advance-after=\"7s\"><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#f3d9d9\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-f83308b3-5f28-4573-825a-ab927f2d51f6\">\n<div style=\"position:absolute;width:118.57814%;height:100%;left:-9.28907%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1581087724844-037b13e16b0b?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=6630&amp;h=9940&amp;fit=max\" alt=\"woman in black shirt using computer\" srcSet=\"https:\/\/images.unsplash.com\/photo-1581087724844-037b13e16b0b?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=6630&amp;h=9940&amp;fit=max 6630w,https:\/\/images.unsplash.com\/photo-1581087724844-037b13e16b0b?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=5304&amp;h=7952&amp;fit=max 5304w,https:\/\/images.unsplash.com\/photo-1581087724844-037b13e16b0b?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=3978&amp;h=5964&amp;fit=max 3978w,https:\/\/images.unsplash.com\/photo-1581087724844-037b13e16b0b?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=2652&amp;h=3976&amp;fit=max 2652w,https:\/\/images.unsplash.com\/photo-1581087724844-037b13e16b0b?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=1326&amp;h=1988&amp;fit=max 1326w,https:\/\/images.unsplash.com\/photo-1581087724844-037b13e16b0b?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=340&amp;h=510&amp;fit=max 340w\" sizes=\"(min-width: 1024px) 53vh, 119vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<div class=\"element-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:5.82524%;top:59.70874%;width:78.64078%;height:26.3754%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6172839506172839% 0.6172839506172839% 0.6172839506172839% 0.6172839506172839% \/ 1.2269938650306749% 1.2269938650306749% 1.2269938650306749% 1.2269938650306749%\" id=\"el-e0f383a5-b14a-45a7-8abf-373611692163\">\n<h1 id=\"data-warehouse-components\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:2.1643518518518516% 0;font-family:&quot;Oranienbaum&quot;,serif;font-size:0.889968em;line-height:0.9;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #fff\">Data Warehouse Components<\/span><\/span><\/h1>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:5.82524%;top:88.99676%;width:94.41748%;height:5.66343%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5141388174807198% 0.5141388174807198% 0.5141388174807198% 0.5141388174807198% \/ 5.714285714285714% 5.714285714285714% 5.714285714285714% 5.714285714285714%\" id=\"el-09cd7155-cbec-4f5e-a262-a2aeb4213165\">\n<h2 id=\"an-overview\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.10845115681233934% 0;font-family:&quot;Roboto&quot;,sans-serif;font-size:0.485437em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #c9184a\">An Overview&nbsp;<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-0.72816%;top:-6.47249%;width:43.68932%;height:9.70874%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-ea251a16-bb73-4d60-8d67-8b48c3a5f099\">\n<div style=\"position:absolute;width:100.28251%;height:100%;left:-0.14125%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png\" alt=\"InterviewBit-White-2\" srcSet=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png 2130w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png 2048w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png 1536w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png 1024w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png 768w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png 300w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png 150w\" sizes=\"(min-width: 1024px) 20vh, 44vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><\/amp-story-page><amp-story-page id=\"f4981294-aa5d-488c-8a6c-880eb6a310bc\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-a4ef8ecd-d2a4-4cd0-ac64-85a4ecb31e5b\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-1c8e699d-e3d9-4a0f-b637-54dfd85cc521\",\"keyframes\":{\"transform\":[\"translate3d(0px, -306.9445%, 0)\",\"translate3d(0px, 0px, 0)\"]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-752103f0-9f96-4495-8d8a-56cc601975e4\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-d116c486-74f4-4594-a83e-cea0de978fe9\",\"keyframes\":{\"transform\":[\"translate3d(0px, -286.85635%, 0)\",\"translate3d(0px, 0px, 0)\"]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-8f4f226d-4599-42a0-8d7f-d41c4f5b75b9 [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate3d(7.812499744007886%, 0, 0) translate(25%, 0%) scale(1.5)\",\"translate3d(0%, 0, 0) translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.14,.34,.47,.9)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#d9d9d9\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div id=\"anim-8f4f226d-4599-42a0-8d7f-d41c4f5b75b9\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-45edd8cc-1669-4671-acd2-9562350a0232\">\n<div style=\"position:absolute;width:118.51852%;height:100%;left:-9.25926%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1507537297725-24a1c029d3ca?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=3456&amp;h=5184&amp;fit=max\" alt=\"man writing on white paper\" srcSet=\"https:\/\/images.unsplash.com\/photo-1507537297725-24a1c029d3ca?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=3456&amp;h=5184&amp;fit=max 3456w,https:\/\/images.unsplash.com\/photo-1507537297725-24a1c029d3ca?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=2764&amp;h=4146&amp;fit=max 2764w,https:\/\/images.unsplash.com\/photo-1507537297725-24a1c029d3ca?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=2073&amp;h=3110&amp;fit=max 2073w,https:\/\/images.unsplash.com\/photo-1507537297725-24a1c029d3ca?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=1382&amp;h=2073&amp;fit=max 1382w,https:\/\/images.unsplash.com\/photo-1507537297725-24a1c029d3ca?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=691&amp;h=1037&amp;fit=max 691w,https:\/\/images.unsplash.com\/photo-1507537297725-24a1c029d3ca?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=340&amp;h=510&amp;fit=max 340w\" sizes=\"(min-width: 1024px) 53vh, 119vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<div class=\"element-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:-13.83495%;top:39.80583%;width:139.56311%;height:59.54693%;transform:rotate(10deg);opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-32431722-a962-4a78-b7b9-ceb62b7c2245\">\n<div class=\"fill\" style=\"background-color:rgba(201,24,74,0.5);will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:8.00971%;top:49.67638%;width:84.95146%;height:28.47896%;opacity:1\">\n<div id=\"anim-a4ef8ecd-d2a4-4cd0-ac64-85a4ecb31e5b\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-1c8e699d-e3d9-4a0f-b637-54dfd85cc521\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:translate3d(0px, -306.9445%, 0)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5714285714285714% 0.5714285714285714% 0.5714285714285714% 0.5714285714285714% \/ 1.1363636363636365% 1.1363636363636365% 1.1363636363636365% 1.1363636363636365%\" id=\"el-e7c1e468-0b2f-424a-a0ce-637c4d6f0af8\">\n<p class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:1.9542857142857144% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.485437em;line-height:0.9;text-align:initial;padding:0;color:#000000\"><span><span style=\"color: #fff\">A central repository where raw data is transformed and stored in a queryable format. It includes commutative and historical data from single or multiple sources.<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:6.06796%;top:15.53398%;width:88.83495%;height:13.26861%;opacity:1\">\n<div id=\"anim-752103f0-9f96-4495-8d8a-56cc601975e4\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-d116c486-74f4-4594-a83e-cea0de978fe9\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:translate3d(0px, -286.85635%, 0)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.546448087431694% 0.546448087431694% 0.546448087431694% 0.546448087431694% \/ 2.4390243902439024% 2.4390243902439024% 2.4390243902439024% 2.4390243902439024%\" id=\"el-6e9d2941-9828-4fb0-9659-31fedc6f84fc\">\n<h2 id=\"introduction-to-data-warehouse\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.13447745901639344% 0;font-family:&quot;Roboto&quot;,sans-serif;font-size:0.566343em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #fff\">Introduction to Data Warehouse<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-0.72816%;top:-6.47249%;width:43.68932%;height:9.70874%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-6cc1faa7-56dc-433b-8519-79268c4850b9\">\n<div style=\"position:absolute;width:100.28251%;height:100%;left:-0.14125%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png\" alt=\"InterviewBit-White-2\" srcSet=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png 2130w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png 2048w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png 1536w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png 1024w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png 768w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png 300w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png 150w\" sizes=\"(min-width: 1024px) 20vh, 44vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-page-outlink layout=\"nodisplay\" cta-image=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/Components-of-Data-Warehouse-1-2048x1000.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/components-of-data-warehouse\/?utm_source=Ib&amp;utm_medium=components-of-data-warehouse&amp;utm_campaign=webstories\" rel=\"\">Read More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"7475a312-090b-4904-a1e7-c092b5a9d208\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-f704e92d-c0c1-43f6-bfb4-ae246b615c39\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-d25b7833-0122-46b5-8a20-beb695164242\",\"keyframes\":{\"transform\":[\"translate3d(0px, -285.33112%, 0)\",\"translate3d(0px, 0px, 0)\"]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-073260fe-4534-4256-b653-36e937889e2d [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate3d(7.812499744007886%, 0, 0) translate(25%, 0%) scale(1.5)\",\"translate3d(0%, 0, 0) translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.14,.34,.47,.9)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-7165b955-7b7b-4682-a9fa-4596d5b27c7e\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-0c49fb18-6a48-461d-9b6d-a6b4ce2b9901\",\"keyframes\":{\"transform\":[\"translate3d(0px, -307.58806%, 0)\",\"translate3d(0px, 0px, 0)\"]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#f3f3f3\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div id=\"anim-073260fe-4534-4256-b653-36e937889e2d\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-7cf9d1d8-3d90-467c-8891-d45926c8b211\">\n<div style=\"position:absolute;width:118.51852%;height:100%;left:-9.25926%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/flagged\/photo-1563536310477-c7b4e3a800c2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1N3x8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzMzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=4000&amp;h=6000&amp;fit=max\" alt=\"woman leaning at the table\" srcSet=\"https:\/\/images.unsplash.com\/flagged\/photo-1563536310477-c7b4e3a800c2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1N3x8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzMzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=4000&amp;h=6000&amp;fit=max 4000w,https:\/\/images.unsplash.com\/flagged\/photo-1563536310477-c7b4e3a800c2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1N3x8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzMzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=3200&amp;h=4800&amp;fit=max 3200w,https:\/\/images.unsplash.com\/flagged\/photo-1563536310477-c7b4e3a800c2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1N3x8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzMzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=2400&amp;h=3600&amp;fit=max 2400w,https:\/\/images.unsplash.com\/flagged\/photo-1563536310477-c7b4e3a800c2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1N3x8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzMzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=1600&amp;h=2400&amp;fit=max 1600w,https:\/\/images.unsplash.com\/flagged\/photo-1563536310477-c7b4e3a800c2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1N3x8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzMzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=800&amp;h=1200&amp;fit=max 800w,https:\/\/images.unsplash.com\/flagged\/photo-1563536310477-c7b4e3a800c2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1N3x8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzMzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=340&amp;h=510&amp;fit=max 340w\" sizes=\"(min-width: 1024px) 53vh, 119vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<div class=\"element-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:-13.83495%;top:39.80583%;width:139.56311%;height:59.54693%;transform:rotate(10deg);opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-7aebd8ed-b1ba-4a77-90fb-48099ace3441\">\n<div class=\"fill\" style=\"background-color:rgba(201,24,74,0.5);will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:6.31068%;top:51.61812%;width:86.8932%;height:32.8479%;opacity:1\">\n<div id=\"anim-f704e92d-c0c1-43f6-bfb4-ae246b615c39\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-d25b7833-0122-46b5-8a20-beb695164242\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:translate3d(0px, -285.33112%, 0)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5586592178770949% 0.5586592178770949% 0.5586592178770949% 0.5586592178770949% \/ 0.9852216748768473% 0.9852216748768473% 0.9852216748768473% 0.9852216748768473%\" id=\"el-89e0b125-ab89-4efb-bf13-d9d129cc75e2\">\n<p class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:1.910614525139665% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.485437em;line-height:0.9;text-align:initial;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #fff\">1. Data Warehouse Database&nbsp;<\/span><\/p>\n<p><span style=\"color: #fff\">A database stores all company data and makes it manageable to report. Database types can be relational, analytical, cloud-based, or data warehouse applications.<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-0.72816%;top:-6.47249%;width:43.68932%;height:9.70874%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-02b12203-ca5e-46c5-a6b5-5d807cb104c2\">\n<div style=\"position:absolute;width:100.28251%;height:100%;left:-0.14125%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png\" alt=\"InterviewBit-White-2\" srcSet=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png 2130w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png 2048w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png 1536w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png 1024w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png 768w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png 300w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png 150w\" sizes=\"(min-width: 1024px) 20vh, 44vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:7.76699%;top:18.28479%;width:88.83495%;height:13.26861%;opacity:1\">\n<div id=\"anim-7165b955-7b7b-4682-a9fa-4596d5b27c7e\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-0c49fb18-6a48-461d-9b6d-a6b4ce2b9901\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:translate3d(0px, -307.58806%, 0)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.546448087431694% 0.546448087431694% 0.546448087431694% 0.546448087431694% \/ 2.4390243902439024% 2.4390243902439024% 2.4390243902439024% 2.4390243902439024%\" id=\"el-221deb50-fa6c-4eea-aff1-08b86e2e7e7d\">\n<h2 id=\"components-of-data-warehouse\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.13447745901639344% 0;font-family:&quot;Roboto&quot;,sans-serif;font-size:0.566343em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #fff\">Components of Data Warehouse<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-page-outlink layout=\"nodisplay\" cta-image=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/Components-of-Data-Warehouse-1-2048x1000.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/components-of-data-warehouse\/?utm_source=Ib&amp;utm_medium=components-of-data-warehouse&amp;utm_campaign=webstories\" rel=\"\">Read More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"cd57867d-e34a-4b0c-af12-ad492d46f078\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-cf9d2733-1ab4-4173-9e29-8a4a37e4255d\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-d47fb825-4943-4fba-9523-cb12d93a11a4\",\"keyframes\":{\"transform\":[\"translate3d(0px, -213.10643%, 0)\",\"translate3d(0px, 0px, 0)\"]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-4a719f13-b601-472b-a756-c480af4ffe6d [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate3d(6.846869328454303%, 0, 0) translate(25%, 0%) scale(1.5)\",\"translate3d(0%, 0, 0) translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.14,.34,.47,.9)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#d9d9c0\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div id=\"anim-4a719f13-b601-472b-a756-c480af4ffe6d\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-048aa9e4-e712-4700-a606-585ab62d5d29\">\n<div style=\"position:absolute;width:115.86645%;height:100%;left:-7.93323%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1616740793717-0aca29b92221?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNHx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=3466&amp;h=5318&amp;fit=max\" alt=\"woman in red blazer holding white paper\" srcSet=\"https:\/\/images.unsplash.com\/photo-1616740793717-0aca29b92221?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNHx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=3466&amp;h=5318&amp;fit=max 3466w,https:\/\/images.unsplash.com\/photo-1616740793717-0aca29b92221?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNHx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=2772&amp;h=4253&amp;fit=max 2772w,https:\/\/images.unsplash.com\/photo-1616740793717-0aca29b92221?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNHx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=2079&amp;h=3190&amp;fit=max 2079w,https:\/\/images.unsplash.com\/photo-1616740793717-0aca29b92221?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNHx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=1386&amp;h=2127&amp;fit=max 1386w,https:\/\/images.unsplash.com\/photo-1616740793717-0aca29b92221?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNHx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=693&amp;h=1063&amp;fit=max 693w,https:\/\/images.unsplash.com\/photo-1616740793717-0aca29b92221?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNHx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=340&amp;h=522&amp;fit=max 340w\" sizes=\"(min-width: 1024px) 52vh, 116vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<div class=\"element-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:-13.83495%;top:39.80583%;width:139.56311%;height:59.54693%;transform:rotate(10deg);opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-41a0e586-58a3-43b7-a176-5ab26a7b4b8d\">\n<div class=\"fill\" style=\"background-color:rgba(201,24,74,0.5);will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:8.25243%;top:42.71845%;width:89.32039%;height:45.95469%;opacity:1\">\n<div id=\"anim-cf9d2733-1ab4-4173-9e29-8a4a37e4255d\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-d47fb825-4943-4fba-9523-cb12d93a11a4\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:translate3d(0px, -213.10643%, 0)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5434782608695652% 0.5434782608695652% 0.5434782608695652% 0.5434782608695652% \/ 0.7042253521126761% 0.7042253521126761% 0.7042253521126761% 0.7042253521126761%\" id=\"el-d7e796ac-1eee-4deb-930d-464ae64fed1d\">\n<p class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:1.8586956521739129% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.485437em;line-height:0.9;text-align:initial;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #fff\">2. Sourcing, Acquisition, Cleanup, and Transformation Tools (ETL)<\/span><\/p>\n<p><span style=\"color: #fff\">The tool performs all summarizations, conversions, structural changes, key changes, and condensations required to convert disparate data into decision support data.<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-0.72816%;top:-6.47249%;width:43.68932%;height:9.70874%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-6bd2e494-0066-4b59-8260-9658bd46986e\">\n<div style=\"position:absolute;width:100.28251%;height:100%;left:-0.14125%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png\" alt=\"InterviewBit-White-2\" srcSet=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png 2130w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png 2048w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png 1536w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png 1024w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png 768w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png 300w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png 150w\" sizes=\"(min-width: 1024px) 20vh, 44vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-page-outlink layout=\"nodisplay\" cta-image=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/Components-of-Data-Warehouse-1-2048x1000.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/components-of-data-warehouse\/?utm_source=Ib&amp;utm_medium=components-of-data-warehouse&amp;utm_campaign=webstories\" rel=\"\">Read More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"31fdfdff-2dbc-4ebb-8700-095521d60841\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-791d7ccb-a570-48d4-92fa-4fd571df9b2c\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-af446599-135b-43e6-a77c-4ff1c73796ed\",\"keyframes\":{\"transform\":[\"translate3d(0px, -253.80882%, 0)\",\"translate3d(0px, 0px, 0)\"]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-d14047b6-aed4-415f-ab9d-62493a7b9c53 [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate3d(7.868525640762189%, 0, 0) translate(25%, 0%) scale(1.5)\",\"translate3d(0%, 0, 0) translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.14,.34,.47,.9)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#f3f3f3\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div id=\"anim-d14047b6-aed4-415f-ab9d-62493a7b9c53\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-e7faba9e-a9a1-4f05-819d-72f2dffc8df2\">\n<div style=\"position:absolute;width:118.67612%;height:100%;left:-9.33806%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1573495783323-9e59a325d4b4?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3MHx8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzNjE&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=4016&amp;h=6016&amp;fit=max\" alt=\"shallow focus photo of woman using MacBook\" srcSet=\"https:\/\/images.unsplash.com\/photo-1573495783323-9e59a325d4b4?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3MHx8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzNjE&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=4016&amp;h=6016&amp;fit=max 4016w,https:\/\/images.unsplash.com\/photo-1573495783323-9e59a325d4b4?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3MHx8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzNjE&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=3212&amp;h=4812&amp;fit=max 3212w,https:\/\/images.unsplash.com\/photo-1573495783323-9e59a325d4b4?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3MHx8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzNjE&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=2409&amp;h=3609&amp;fit=max 2409w,https:\/\/images.unsplash.com\/photo-1573495783323-9e59a325d4b4?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3MHx8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzNjE&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=1606&amp;h=2406&amp;fit=max 1606w,https:\/\/images.unsplash.com\/photo-1573495783323-9e59a325d4b4?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3MHx8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzNjE&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=803&amp;h=1203&amp;fit=max 803w,https:\/\/images.unsplash.com\/photo-1573495783323-9e59a325d4b4?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3MHx8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzNjE&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=340&amp;h=509&amp;fit=max 340w\" sizes=\"(min-width: 1024px) 53vh, 119vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<div class=\"element-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:-13.83495%;top:39.80583%;width:139.56311%;height:59.54693%;transform:rotate(10deg);opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-e564704d-ee72-4d2a-b3f2-522089917dca\">\n<div class=\"fill\" style=\"background-color:rgba(201,24,74,0.5);will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:8.00971%;top:47.73463%;width:85.67961%;height:37.05502%;opacity:1\">\n<div id=\"anim-791d7ccb-a570-48d4-92fa-4fd571df9b2c\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-af446599-135b-43e6-a77c-4ff1c73796ed\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:translate3d(0px, -253.80882%, 0)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.56657223796034% 0.56657223796034% 0.56657223796034% 0.56657223796034% \/ 0.8733624454148471% 0.8733624454148471% 0.8733624454148471% 0.8733624454148471%\" id=\"el-d7950025-27d2-4422-aa84-506fcb59ffca\">\n<p class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:1.9376770538243624% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.485437em;line-height:0.9;text-align:initial;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #fff\">3. Metadata<\/span><span style=\"color: #fff\">&nbsp;<\/span><\/p>\n<p><span style=\"color: #fff\">Metadata serves as a framework for data in the data warehouse architecture. Assists in handling, maintaining, constructing, and utilizing data warehouses.<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-0.72816%;top:-6.47249%;width:43.68932%;height:9.70874%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-5339da21-7a91-4913-9d78-9538a6c595fd\">\n<div style=\"position:absolute;width:100.28251%;height:100%;left:-0.14125%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png\" alt=\"InterviewBit-White-2\" srcSet=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png 2130w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png 2048w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png 1536w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png 1024w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png 768w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png 300w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png 150w\" sizes=\"(min-width: 1024px) 20vh, 44vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-page-outlink layout=\"nodisplay\" cta-image=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/Components-of-Data-Warehouse-1-2048x1000.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/components-of-data-warehouse\/?utm_source=Ib&amp;utm_medium=components-of-data-warehouse&amp;utm_campaign=webstories\" rel=\"\">Read More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"c5932a30-dcd5-4c37-bf3b-7ce1e2efa63e\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-e3436b16-c6fa-4940-bc4b-937ffbc8d9cc\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-6cc94cfa-d7a5-459e-84ec-04e2dcb14d40\",\"keyframes\":{\"transform\":[\"translate3d(0px, -252.49877%, 0)\",\"translate3d(0px, 0px, 0)\"]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-d6ab1162-d4fb-4e34-8053-749550616226 [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate3d(31.249999886225726%, 0, 0) translate(25%, 0%) scale(1.5)\",\"translate3d(0%, 0, 0) translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.14,.34,.47,.9)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#f3f3f3\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div id=\"anim-d6ab1162-d4fb-4e34-8053-749550616226\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-f35b4618-d680-4765-b972-9b65a643b5b0\">\n<div style=\"position:absolute;width:266.66667%;height:100%;left:-83.33334%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1583508915901-b5f84c1dcde1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTEw&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=6000&amp;h=4000&amp;fit=max\" alt=\"man in gray dress shirt sitting on chair in front of computer monitor\" srcSet=\"https:\/\/images.unsplash.com\/photo-1583508915901-b5f84c1dcde1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTEw&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=6000&amp;h=4000&amp;fit=max 6000w,https:\/\/images.unsplash.com\/photo-1583508915901-b5f84c1dcde1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTEw&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=4800&amp;h=3200&amp;fit=max 4800w,https:\/\/images.unsplash.com\/photo-1583508915901-b5f84c1dcde1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTEw&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=3600&amp;h=2400&amp;fit=max 3600w,https:\/\/images.unsplash.com\/photo-1583508915901-b5f84c1dcde1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTEw&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=2400&amp;h=1600&amp;fit=max 2400w,https:\/\/images.unsplash.com\/photo-1583508915901-b5f84c1dcde1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTEw&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=1200&amp;h=800&amp;fit=max 1200w,https:\/\/images.unsplash.com\/photo-1583508915901-b5f84c1dcde1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTEw&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=340&amp;h=227&amp;fit=max 340w\" sizes=\"(min-width: 1024px) 120vh, 267vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<div class=\"element-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:-13.83495%;top:39.80583%;width:139.56311%;height:59.54693%;transform:rotate(10deg);opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-0436c217-eff4-400f-b5f3-0f7b3ba97871\">\n<div class=\"fill\" style=\"background-color:rgba(201,24,74,0.5);will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:8.73786%;top:47.24919%;width:84.95146%;height:37.05502%;opacity:1\">\n<div id=\"anim-e3436b16-c6fa-4940-bc4b-937ffbc8d9cc\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-6cc94cfa-d7a5-459e-84ec-04e2dcb14d40\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:translate3d(0px, -252.49877%, 0)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5714285714285714% 0.5714285714285714% 0.5714285714285714% 0.5714285714285714% \/ 0.8733624454148471% 0.8733624454148471% 0.8733624454148471% 0.8733624454148471%\" id=\"el-7cbe63a3-d2a9-44ee-9294-63419067274d\">\n<p class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:1.9542857142857144% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.485437em;line-height:0.9;text-align:initial;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #fff\">4. Query Tools&nbsp;<\/span><\/p>\n<p><span style=\"color: #fff\">With query tools, you can access data and the database catalog, create and implement SQL queries, and manage database objects and database users.<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-0.72816%;top:-6.47249%;width:43.68932%;height:9.70874%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-11905f15-a6e1-4923-b588-85de48a1dac6\">\n<div style=\"position:absolute;width:100.28251%;height:100%;left:-0.14125%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png\" alt=\"InterviewBit-White-2\" srcSet=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png 2130w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png 2048w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png 1536w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png 1024w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png 768w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png 300w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png 150w\" sizes=\"(min-width: 1024px) 20vh, 44vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-page-outlink layout=\"nodisplay\" cta-image=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/Components-of-Data-Warehouse-1-2048x1000.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/components-of-data-warehouse\/?utm_source=Ib&amp;utm_medium=components-of-data-warehouse&amp;utm_campaign=webstories\" rel=\"\">Read More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"59648b7b-0c10-472f-b028-64381c1481fa\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-d9c1c7bd-9a32-4b25-9e2d-aed281fe913f\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-1edae101-3f32-4edd-ac5f-008e3d040d53\",\"keyframes\":{\"transform\":[\"translate3d(0px, -234.71681%, 0)\",\"translate3d(0px, 0px, 0)\"]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-159b2792-af53-4dee-921f-233c9f6668b9 [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate3d(7.8337101513764065%, 0, 0) translate(25%, 0%) scale(1.5)\",\"translate3d(0%, 0, 0) translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.14,.34,.47,.9)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#c0d9c0\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div id=\"anim-159b2792-af53-4dee-921f-233c9f6668b9\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-f35b4618-d680-4765-b972-9b65a643b5b0\">\n<div style=\"position:absolute;width:118.57814%;height:100%;left:-9.28907%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2MHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTUz&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=5304&amp;h=7952&amp;fit=max\" alt=\"man in pink button up shirt sitting beside woman in blue and black shirt\" srcSet=\"https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2MHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTUz&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=5304&amp;h=7952&amp;fit=max 5304w,https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2MHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTUz&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=4243&amp;h=6361&amp;fit=max 4243w,https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2MHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTUz&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=3182&amp;h=4771&amp;fit=max 3182w,https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2MHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTUz&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=2121&amp;h=3180&amp;fit=max 2121w,https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2MHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTUz&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=1060&amp;h=1589&amp;fit=max 1060w,https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2MHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTUz&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=340&amp;h=510&amp;fit=max 340w\" sizes=\"(min-width: 1024px) 53vh, 119vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<div class=\"element-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:-13.83495%;top:39.80583%;width:139.56311%;height:59.54693%;transform:rotate(10deg);opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-797d9e93-9457-4e1b-b291-fa258c04f11b\">\n<div class=\"fill\" style=\"background-color:rgba(201,24,74,0.5);will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:8.00971%;top:46.76375%;width:84.95146%;height:41.58576%;opacity:1\">\n<div id=\"anim-d9c1c7bd-9a32-4b25-9e2d-aed281fe913f\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-1edae101-3f32-4edd-ac5f-008e3d040d53\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:translate3d(0px, -234.71681%, 0)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5714285714285714% 0.5714285714285714% 0.5714285714285714% 0.5714285714285714% \/ 0.7782101167315175% 0.7782101167315175% 0.7782101167315175% 0.7782101167315175%\" id=\"el-32ca8626-54b5-43a4-97b6-0c0e3117794b\">\n<p class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:1.9542857142857144% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.485437em;line-height:0.9;text-align:initial;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #fff\">5. Data Marts&nbsp;<\/span><\/p>\n<p><span style=\"color: #fff\">A subset of data warehouses focused on particular lines of business, departments, or subject areas. Insights can be accessed instantly without searching through entire data warehouses.<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-0.72816%;top:-6.47249%;width:43.68932%;height:9.70874%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-64f0cf5b-d094-4a3f-a889-8a6a84877d81\">\n<div style=\"position:absolute;width:100.28251%;height:100%;left:-0.14125%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png\" alt=\"InterviewBit-White-2\" srcSet=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png 2130w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png 2048w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png 1536w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png 1024w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png 768w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png 300w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png 150w\" sizes=\"(min-width: 1024px) 20vh, 44vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-page-outlink layout=\"nodisplay\" cta-image=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/Components-of-Data-Warehouse-1-2048x1000.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/components-of-data-warehouse\/?utm_source=Ib&amp;utm_medium=components-of-data-warehouse&amp;utm_campaign=webstories\" rel=\"\">Read More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"aec8b6f0-f2ad-48e0-85b7-a304034b1979\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-c5a85431-94b3-42a1-be9f-15cc0b9b4e86\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-b80435fb-56e7-4256-a11f-16aa8348c98b\",\"keyframes\":{\"transform\":[\"translate3d(0px, -221.98665%, 0)\",\"translate3d(0px, 0px, 0)\"]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-e52867c1-b95d-4532-9ba7-955672543fda [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate3d(31.225066375436132%, 0, 0) translate(25%, 0%) scale(1.5)\",\"translate3d(0%, 0, 0) translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.14,.34,.47,.9)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#f3f3f3\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div id=\"anim-e52867c1-b95d-4532-9ba7-955672543fda\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-1dcabe56-8396-4f79-a746-181ea8ee0c35\">\n<div style=\"position:absolute;width:266.31253%;height:100%;left:-83.15627%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1573164574397-dd250bc8a598?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3OHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMTk4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=6016&amp;h=4016&amp;fit=max\" alt=\"photography of three women sits beside table inside room during daytime\" srcSet=\"https:\/\/images.unsplash.com\/photo-1573164574397-dd250bc8a598?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3OHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMTk4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=6016&amp;h=4016&amp;fit=max 6016w,https:\/\/images.unsplash.com\/photo-1573164574397-dd250bc8a598?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3OHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMTk4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=4812&amp;h=3212&amp;fit=max 4812w,https:\/\/images.unsplash.com\/photo-1573164574397-dd250bc8a598?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3OHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMTk4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=3609&amp;h=2409&amp;fit=max 3609w,https:\/\/images.unsplash.com\/photo-1573164574397-dd250bc8a598?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3OHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMTk4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=2406&amp;h=1606&amp;fit=max 2406w,https:\/\/images.unsplash.com\/photo-1573164574397-dd250bc8a598?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3OHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMTk4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=1203&amp;h=803&amp;fit=max 1203w,https:\/\/images.unsplash.com\/photo-1573164574397-dd250bc8a598?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3OHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMTk4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=340&amp;h=227&amp;fit=max 340w\" sizes=\"(min-width: 1024px) 120vh, 267vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<div class=\"element-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:-13.83495%;top:39.80583%;width:139.56311%;height:59.54693%;transform:rotate(10deg);opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-cc37024e-f5c9-45f3-b1fc-3d6ddf052868\">\n<div class=\"fill\" style=\"background-color:rgba(201,24,74,0.5);will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:4.85437%;top:46.60194%;width:92.96117%;height:45.79288%;opacity:1\">\n<div id=\"anim-c5a85431-94b3-42a1-be9f-15cc0b9b4e86\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-b80435fb-56e7-4256-a11f-16aa8348c98b\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:translate3d(0px, -221.98665%, 0)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5221932114882507% 0.5221932114882507% 0.5221932114882507% 0.5221932114882507% \/ 0.7067137809187279% 0.7067137809187279% 0.7067137809187279% 0.7067137809187279%\" id=\"el-4661c22c-6637-49e7-9674-aed9476ae70b\">\n<p class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:1.785900783289817% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.485437em;line-height:0.9;text-align:initial;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #fff\">6. Data Warehouse Management and Administration&nbsp;<\/span><br \/>\n<span style=\"color: #fff\">Managing data warehouses includes: &nbsp;<\/span><\/p>\n<p><span style=\"color: #fff\">&#8211; Security &amp; priority management&nbsp;<\/span><br \/>\n<span style=\"color: #fff\">&#8211; Data quality checks&nbsp;<\/span><br \/>\n<span style=\"color: #fff\">&#8211; Managing &amp; Updating meta data&nbsp;<\/span><br \/>\n<span style=\"color: #fff\">&#8211; Purging data&nbsp;<\/span><\/p>\n<p><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-0.72816%;top:-6.47249%;width:43.68932%;height:9.70874%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-5a4f926a-dc4f-49dd-a1e8-22b7a2b10cd6\">\n<div style=\"position:absolute;width:100.28251%;height:100%;left:-0.14125%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png\" alt=\"InterviewBit-White-2\" srcSet=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png 2130w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png 2048w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png 1536w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png 1024w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png 768w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png 300w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png 150w\" sizes=\"(min-width: 1024px) 20vh, 44vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-page-outlink layout=\"nodisplay\" cta-image=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/Components-of-Data-Warehouse-1-2048x1000.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/components-of-data-warehouse\/?utm_source=Ib&amp;utm_medium=components-of-data-warehouse&amp;utm_campaign=webstories\" rel=\"\">Read More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"58a6e883-6943-4333-9ae1-d6cab2cae5f9\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-d21e4561-74a7-483e-8c94-e0359b22e9e2 [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate3d(28.90624987200394%, 0, 0) translate(25%, 0%) scale(1.5)\",\"translate3d(0%, 0, 0) translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.14,.34,.47,.9)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-a3f1849f-a2ce-4b4d-beeb-1fbfcb618031\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-7918b510-bc29-4c0d-83b1-619b87168ebc\",\"keyframes\":{\"transform\":[\"translate3d(0px, -258.3575%, 0)\",\"translate3d(0px, 0px, 0)\"]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#262626\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div id=\"anim-d21e4561-74a7-483e-8c94-e0359b22e9e2\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-1dcabe56-8396-4f79-a746-181ea8ee0c35\">\n<div style=\"position:absolute;width:237.03704%;height:100%;left:-68.51852%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1531497865144-0464ef8fb9a9?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw4M3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=5184&amp;h=3888&amp;fit=max\" alt=\"people inside room\" srcSet=\"https:\/\/images.unsplash.com\/photo-1531497865144-0464ef8fb9a9?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw4M3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=5184&amp;h=3888&amp;fit=max 5184w,https:\/\/images.unsplash.com\/photo-1531497865144-0464ef8fb9a9?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw4M3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=4147&amp;h=3110&amp;fit=max 4147w,https:\/\/images.unsplash.com\/photo-1531497865144-0464ef8fb9a9?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw4M3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=3110&amp;h=2333&amp;fit=max 3110w,https:\/\/images.unsplash.com\/photo-1531497865144-0464ef8fb9a9?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw4M3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=2073&amp;h=1555&amp;fit=max 2073w,https:\/\/images.unsplash.com\/photo-1531497865144-0464ef8fb9a9?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw4M3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=1036&amp;h=777&amp;fit=max 1036w,https:\/\/images.unsplash.com\/photo-1531497865144-0464ef8fb9a9?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw4M3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=340&amp;h=255&amp;fit=max 340w\" sizes=\"(min-width: 1024px) 107vh, 238vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<div class=\"element-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.5)\"><\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:-13.83495%;top:39.80583%;width:139.56311%;height:59.54693%;transform:rotate(10deg);opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-c9279071-accf-4dc4-98b7-888955b3d394\">\n<div class=\"fill\" style=\"background-color:rgba(201,24,74,0.5);will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-0.72816%;top:-6.47249%;width:43.68932%;height:9.70874%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-ae40af70-da94-4b1d-ad64-befe800a9787\">\n<div style=\"position:absolute;width:100.28251%;height:100%;left:-0.14125%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png\" alt=\"InterviewBit-White-2\" srcSet=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png 2130w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png 2048w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png 1536w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png 1024w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png 768w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png 300w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png 150w\" sizes=\"(min-width: 1024px) 20vh, 44vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:6.31068%;top:49.67638%;width:87.37864%;height:37.21683%;opacity:1\">\n<div id=\"anim-a3f1849f-a2ce-4b4d-beeb-1fbfcb618031\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-7918b510-bc29-4c0d-83b1-619b87168ebc\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:translate3d(0px, -258.3575%, 0)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5555555555555556% 0.5555555555555556% 0.5555555555555556% 0.5555555555555556% \/ 0.8695652173913043% 0.8695652173913043% 0.8695652173913043% 0.8695652173913043%\" id=\"el-1ebda62d-150a-49ce-82a2-3b049adc0b17\">\n<p class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:1.9% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.485437em;line-height:0.9;text-align:initial;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #fff\">7. Information Delivery System<\/span><\/p>\n<p><span style=\"color: #fff\">Allocate data from the warehouse and information objects to different data warehouses and end-user products like local databases and spreadsheets.<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-page-outlink layout=\"nodisplay\" cta-image=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/Components-of-Data-Warehouse-1-2048x1000.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/components-of-data-warehouse\/?utm_source=Ib&amp;utm_medium=components-of-data-warehouse&amp;utm_campaign=webstories\" rel=\"\">Read More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"4c8e1b8b-8c10-4ac1-a12e-2ccea42ab439\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-90f25256-c100-42c0-bca3-8be2c0214d32\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":1000,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-aabbd1c0-cb6b-4baa-9d74-d0653b39daa0\",\"keyframes\":{\"transform\":[\"translate3d(0px, -181.44166%, 0)\",\"translate3d(0px, 0px, 0)\"]},\"delay\":0,\"duration\":1000,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-0e5e0e21-296e-4f2d-972c-c227bef46f15\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-5c7dd6ed-9ef0-40bd-a535-3e45f143419c\",\"keyframes\":{\"transform\":[\"translate3d(0px, -1772.06357%, 0)\",\"translate3d(0px, 0px, 0)\"]},\"delay\":0,\"duration\":600,\"easing\":\"cubic-bezier(0.2, 0.6, 0.0, 1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\" style=\"background-color:#262626\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:0;top:-9.25926%;width:100%;height:118.51852%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-f4e948f5-d736-4ce4-a3ee-88747553cffd\">\n<div style=\"position:absolute;width:267.66542%;height:100%;left:-83.83271%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1497091071254-cc9b2ba7c48a?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0MHx8cmVzdW1lfGVufDB8fHx8MTY2NjA2MjgxNA&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=4288&amp;h=2848&amp;fit=max\" alt=\"person using track pad\" srcSet=\"https:\/\/images.unsplash.com\/photo-1497091071254-cc9b2ba7c48a?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0MHx8cmVzdW1lfGVufDB8fHx8MTY2NjA2MjgxNA&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=4288&amp;h=2848&amp;fit=max 4288w,https:\/\/images.unsplash.com\/photo-1497091071254-cc9b2ba7c48a?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0MHx8cmVzdW1lfGVufDB8fHx8MTY2NjA2MjgxNA&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=3430&amp;h=2278&amp;fit=max 3430w,https:\/\/images.unsplash.com\/photo-1497091071254-cc9b2ba7c48a?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0MHx8cmVzdW1lfGVufDB8fHx8MTY2NjA2MjgxNA&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=2572&amp;h=1708&amp;fit=max 2572w,https:\/\/images.unsplash.com\/photo-1497091071254-cc9b2ba7c48a?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0MHx8cmVzdW1lfGVufDB8fHx8MTY2NjA2MjgxNA&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=1715&amp;h=1139&amp;fit=max 1715w,https:\/\/images.unsplash.com\/photo-1497091071254-cc9b2ba7c48a?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0MHx8cmVzdW1lfGVufDB8fHx8MTY2NjA2MjgxNA&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=857&amp;h=569&amp;fit=max 857w,https:\/\/images.unsplash.com\/photo-1497091071254-cc9b2ba7c48a?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0MHx8cmVzdW1lfGVufDB8fHx8MTY2NjA2MjgxNA&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=340&amp;h=226&amp;fit=max 340w\" sizes=\"(min-width: 1024px) 121vh, 268vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<div class=\"element-overlay-area\" style=\"background-image:linear-gradient(0.5turn, rgba(0,0,0,0) 40%, rgba(0,0,0,0.5) 100%)\"><\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-image:linear-gradient(0.5turn, rgba(0,0,0,0) 40%, rgba(0,0,0,0.5) 100%)\"><\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-grid-layer template=\"vertical\" aspect-ratio=\"412:618\" class=\"grid-layer\"><\/p>\n<div class=\"page-fullbleed-area\">\n<div class=\"page-safe-area\">\n<div style=\"position:absolute;pointer-events:none;left:4.85437%;top:4.36893%;width:19.66019%;height:45.79288%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" id=\"el-767928e9-9468-438e-bb74-51804c911c2c\">\n<h1 id=\"\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:49.876543209876516% 0;font-family:&quot;Poppins&quot;,sans-serif;font-size:3.268608em;line-height:1;text-align:initial;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #fff\">\u201c<\/span><\/span><\/h1>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:7.28155%;top:47.24919%;width:179.36893%;height:4.36893%;transform:rotate(270deg);opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-c189f7a2-ccce-408a-95ed-7359e651e06d\">\n<div class=\"fill\" style=\"background-color:#c9184a;will-change:transform\"><\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:5.09709%;top:27.50809%;width:80.09709%;height:45.14563%;opacity:1\">\n<div id=\"anim-90f25256-c100-42c0-bca3-8be2c0214d32\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-aabbd1c0-cb6b-4baa-9d74-d0653b39daa0\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:translate3d(0px, -181.44166%, 0)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" id=\"el-54cdc3d5-2ac7-4aa9-9aa7-364e59edb3df\">\n<p class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:1.3636363636363624% 0;font-family:&quot;Poppins&quot;,sans-serif;font-size:0.728155em;line-height:1.2;text-align:initial;padding:0;color:#000000\"><span><span style=\"color: #fff\">Best&nbsp;<\/span><br \/>\n<span style=\"color: #fff\">Practices for Creating Data Warehouse Architecture?<\/span><\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:33.73786%;top:85.43689%;width:48.54369%;height:5.66343%;opacity:1\">\n<div id=\"anim-0e5e0e21-296e-4f2d-972c-c227bef46f15\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:0;--initial-transform:none\">\n<div id=\"anim-5c7dd6ed-9ef0-40bd-a535-3e45f143419c\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:translate3d(0px, -1772.06357%, 0)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:1% 1% 1% 1% \/ 5.714285714285714% 5.714285714285714% 5.714285714285714% 5.714285714285714%\" id=\"el-83d740a7-250d-49cb-b7d9-9712d7d52b7d\">\n<h2 id=\"click-here\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.2109375% 0;font-family:&quot;Roboto&quot;,sans-serif;font-size:0.485437em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #c9184a\">Click Here&#8230;<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:-0.72816%;top:-6.47249%;width:43.68932%;height:9.70874%;opacity:1\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-499f4e5c-961c-4804-8c90-d8db60a5239a\">\n<div style=\"position:absolute;width:100.28251%;height:100%;left:-0.14125%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png\" alt=\"InterviewBit-White-2\" srcSet=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png 2130w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png 2048w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png 1536w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png 1024w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png 768w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png 300w,https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png 150w\" sizes=\"(min-width: 1024px) 20vh, 44vw\" disable-inline-width=\"true\"><\/amp-img><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><\/amp-story-grid-layer><amp-story-page-outlink layout=\"nodisplay\" cta-image=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/Components-of-Data-Warehouse-1-2048x1000.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/components-of-data-warehouse\/?utm_source=Ib&amp;utm_medium=components-of-data-warehouse&amp;utm_campaign=webstories\" rel=\"\">SWIPE UP<\/a><\/amp-story-page-outlink><\/amp-story-page><\/amp-story><\/body><\/html><\/p>\n","protected":false},"excerpt":{"rendered":"In this web story, we are going to provide insight into the various components of the data warehouse.\n","protected":false},"author":21,"featured_media":14454,"template":"","meta":{"_daextam_enable_autolinks":"","web_stories_products":[],"web_stories_publisher_logo":1082,"web_stories_poster":[]},"web_story_category":[1963],"web_story_tag":[1833,1994],"amp_enabled":false,"story_data":{"version":43,"pages":[{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":48,"y":0,"width":330,"height":494,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"f83308b3-5f28-4573-825a-ab927f2d51f6","basedOn":"8fe4f619-7591-4389-b43e-d196bd3f5eb1","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#f3d9d9","blurHash":"LhHn?As.S5WB01RkjZRj?ajuM{of","type":"image","mimeType":"image\/jpeg","creationDate":"2020-02-07T15:17:48Z","src":"https:\/\/images.unsplash.com\/photo-1581087724844-037b13e16b0b?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&ixlib=rb-4.0.3&fm=jpg&w=6630&h=9940&fit=max","width":6630,"height":9940,"id":"media\/unsplash:3cx_tx4h9oI","alt":"woman in black shirt using computer","sizes":{"full":{"file":"media\/unsplash:3cx_tx4h9oI","sourceUrl":"https:\/\/images.unsplash.com\/photo-1581087724844-037b13e16b0b?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&ixlib=rb-4.0.3&fm=jpg&w=6630&h=9940&fit=max","mimeType":"image\/jpeg","width":6630,"height":9940},"large":{"file":"media\/unsplash:3cx_tx4h9oI","sourceUrl":"https:\/\/images.unsplash.com\/photo-1581087724844-037b13e16b0b?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&ixlib=rb-4.0.3&fm=jpg&w=5304&h=7952&fit=max","mimeType":"image\/jpeg","width":5304,"height":7952},"3978_5964":{"file":"media\/unsplash:3cx_tx4h9oI","sourceUrl":"https:\/\/images.unsplash.com\/photo-1581087724844-037b13e16b0b?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&ixlib=rb-4.0.3&fm=jpg&w=3978&h=5964&fit=max","mimeType":"image\/jpeg","width":3978,"height":5964},"2652_3976":{"file":"media\/unsplash:3cx_tx4h9oI","sourceUrl":"https:\/\/images.unsplash.com\/photo-1581087724844-037b13e16b0b?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&ixlib=rb-4.0.3&fm=jpg&w=2652&h=3976&fit=max","mimeType":"image\/jpeg","width":2652,"height":3976},"1326_1988":{"file":"media\/unsplash:3cx_tx4h9oI","sourceUrl":"https:\/\/images.unsplash.com\/photo-1581087724844-037b13e16b0b?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&ixlib=rb-4.0.3&fm=jpg&w=1326&h=1988&fit=max","mimeType":"image\/jpeg","width":1326,"height":1988},"web_stories_thumbnail":{"file":"media\/unsplash:3cx_tx4h9oI","sourceUrl":"https:\/\/images.unsplash.com\/photo-1581087724844-037b13e16b0b?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw5N3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&ixlib=rb-4.0.3&fm=jpg&w=340&h=510&fit=max","mimeType":"image\/jpeg","width":340,"height":510}},"attribution":{"author":{"displayName":"ThisisEngineering RAEng","url":"https:\/\/unsplash.com\/@thisisengineering?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AWJwhCE3txY4%2BnJqL6M1wzcDLXGvI8rtcbgeWkZMZ8YmNrkQiU51qkc7ePECVy%2BtWeqo38KkekKs%2Bg6FJdf9mF1xh%2B%2B19kA3Yf2ldk7qioks3QsXW0svYaIHNsk9tyBjUtVHvANanuI1QGLvg%2B8pdibJzvvtssNx6jhQeRqTPdmkl8Gwl0\/qBlZEa7r3\/3QuXcUmKipFNGOKL%2BEprEEeRVX\/nPX3yN8izz8Xc1hClkFDOrLLCnuxHuHZ07E41XfVBs\/E7A%3D%3D"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.5}}},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"backgroundTextMode":"NONE","font":{"family":"Oranienbaum","fallbacks":["serif"],"weights":[400],"styles":["regular"],"variants":[[0,400]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":895,"des":-260,"tAsc":895,"tDes":-260,"tLGap":0,"wAsc":895,"wDes":260,"xH":475,"capH":700,"yMin":-260,"yMax":895,"hAsc":895,"hDes":-260,"lGap":0}},"fontSize":55,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":0.9,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false},"type":"text","content":"<span style=\"font-weight: 700; color: #fff\">Data Warehouse Components<\/span>","fontWeight":700,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":24,"y":369,"width":324,"height":163,"scale":100,"focalX":50,"focalY":50,"id":"e0f383a5-b14a-45a7-8abf-373611692163","marginOffset":-15.044999999999995,"basedOn":"42d3cd2a-11b2-4f13-9d0c-67510cce933d","groupId":null},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto","fallbacks":["sans-serif"],"weights":[100,300,400,500,700,900],"styles":["italic","regular"],"variants":[[0,100],[1,100],[0,300],[1,300],[0,400],[1,400],[0,500],[1,500],[0,700],[1,700],[0,900],[1,900]],"service":"fonts.google.com","metrics":{"upm":2048,"asc":1900,"des":-500,"tAsc":1536,"tDes":-512,"tLGap":102,"wAsc":1946,"wDes":512,"xH":1082,"capH":1456,"yMin":-555,"yMax":2163,"hAsc":1900,"hDes":-500,"lGap":0}},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"type":"text","content":"<span style=\"font-weight: 700; color: #c9184a\">An Overview&nbsp;<\/span>","borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":24,"y":550,"width":389,"height":35,"scale":100,"focalX":50,"focalY":50,"id":"09cd7155-cbec-4f5e-a262-a2aeb4213165"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":-3,"y":-40,"width":180,"height":60,"mask":{"type":"rectangle"},"type":"image","scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","creationDate":"2021-07-12T14:57:03","src":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png","width":2130,"height":708,"id":724,"alt":"InterviewBit-White-2","sizes":{"medium":{"file":"InterviewBit-White-2-300x100.png","width":300,"height":100,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png"},"large":{"file":"InterviewBit-White-2-1024x340.png","width":1024,"height":340,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png"},"thumbnail":{"file":"InterviewBit-White-2-150x150.png","width":150,"height":150,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x150.png"},"medium_large":{"file":"InterviewBit-White-2-768x255.png","width":768,"height":255,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png"},"1536x1536":{"file":"InterviewBit-White-2-1536x511.png","width":1536,"height":511,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png"},"2048x2048":{"file":"InterviewBit-White-2-2048x681.png","width":2048,"height":681,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png"},"web-stories-poster-portrait":{"file":"InterviewBit-White-2-640x708.png","width":640,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x708.png"},"web-stories-poster-landscape":{"file":"InterviewBit-White-2-853x640.png","width":853,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-853x640.png"},"web-stories-poster-square":{"file":"InterviewBit-White-2-640x640.png","width":640,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x640.png"},"web-stories-publisher-logo":{"file":"InterviewBit-White-2-96x96.png","width":96,"height":96,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-96x96.png"},"web-stories-thumbnail":{"file":"InterviewBit-White-2-150x50.png","width":150,"height":50,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png"},"full":{"file":"InterviewBit-White-2.png","width":2130,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png"}},"isOptimized":false,"isExternal":false},"basedOn":"747a5370-3a95-4a7f-a148-b0f6146a6c43","id":"ea251a16-bb73-4d60-8d67-8b48c3a5f099"}],"animations":[],"backgroundColor":{"color":{"r":0,"g":0,"b":0}},"type":"page","id":"039bee5f-dd9a-4634-90e1-781b45874a59","pageTemplateType":"cover","groups":{"43822f2d-e2ce-445d-ac82-13372d91db61":{"name":"Background","isLocked":true,"isCollapsed":true}},"defaultBackgroundElement":{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"72b1402c-afe3-4407-ad92-d2585cb93d30","basedOn":"8fe4f619-7591-4389-b43e-d196bd3f5eb1"}},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":48,"y":0,"width":330,"height":494,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"45edd8cc-1669-4671-acd2-9562350a0232","basedOn":"8fe4f619-7591-4389-b43e-d196bd3f5eb1","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#d9d9d9","blurHash":"LbJ[02bI-:M{.8ahWCRk~qtRM{oe","type":"image","mimeType":"image\/jpeg","creationDate":"2017-10-09T08:22:28Z","src":"https:\/\/images.unsplash.com\/photo-1507537297725-24a1c029d3ca?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&ixlib=rb-1.2.1&fm=jpg&w=3456&h=5184&fit=max","width":3456,"height":5184,"id":"media\/unsplash:EI50ZDA-l8Y","alt":"man writing on white paper","sizes":{"full":{"file":"media\/unsplash:EI50ZDA-l8Y","sourceUrl":"https:\/\/images.unsplash.com\/photo-1507537297725-24a1c029d3ca?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&ixlib=rb-1.2.1&fm=jpg&w=3456&h=5184&fit=max","mimeType":"image\/jpeg","width":3456,"height":5184},"large":{"file":"media\/unsplash:EI50ZDA-l8Y","sourceUrl":"https:\/\/images.unsplash.com\/photo-1507537297725-24a1c029d3ca?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&ixlib=rb-1.2.1&fm=jpg&w=2764&h=4146&fit=max","mimeType":"image\/jpeg","width":2764,"height":4146},"2073_3110":{"file":"media\/unsplash:EI50ZDA-l8Y","sourceUrl":"https:\/\/images.unsplash.com\/photo-1507537297725-24a1c029d3ca?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&ixlib=rb-1.2.1&fm=jpg&w=2073&h=3110&fit=max","mimeType":"image\/jpeg","width":2073,"height":3110},"1382_2073":{"file":"media\/unsplash:EI50ZDA-l8Y","sourceUrl":"https:\/\/images.unsplash.com\/photo-1507537297725-24a1c029d3ca?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&ixlib=rb-1.2.1&fm=jpg&w=1382&h=2073&fit=max","mimeType":"image\/jpeg","width":1382,"height":2073},"691_1037":{"file":"media\/unsplash:EI50ZDA-l8Y","sourceUrl":"https:\/\/images.unsplash.com\/photo-1507537297725-24a1c029d3ca?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&ixlib=rb-1.2.1&fm=jpg&w=691&h=1037&fit=max","mimeType":"image\/jpeg","width":691,"height":1037},"web_stories_thumbnail":{"file":"media\/unsplash:EI50ZDA-l8Y","sourceUrl":"https:\/\/images.unsplash.com\/photo-1507537297725-24a1c029d3ca?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNXx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&ixlib=rb-1.2.1&fm=jpg&w=340&h=510&fit=max","mimeType":"image\/jpeg","width":340,"height":510}},"attribution":{"author":{"displayName":"LinkedIn Sales Solutions","url":"https:\/\/unsplash.com\/@linkedinsalesnavigator?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4toQJsPEvIQ3Af2nHFDA\/f6JdPDm8BDz\/XW8Bgjsq7s\/kZbD1rrrtHkoytlDakNCFpp7JW5pES58hyR1D7exLnlgOWnh9pMyoaS6qAqP25hdNW%2BwIy8JAEgoz01MTTXy6Tmxob2LkZ\/\/mq6xD2t4DLdHeY%2BCjp7uZyBhvnubB\/oyf3Qmh1rqbP5HZ93YxY8p3C\/YiHbSH4TfeZ1o011iHg3yjw3vyopYX0AXzEaGbg%3D%3D"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.5}}},{"x":-57,"y":246,"basedOn":"e564704d-ee72-4d2a-b3f2-522089917dca","opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":10,"lockAspectRatio":false,"backgroundColor":{"color":{"r":201,"g":24,"b":74,"a":0.5}},"type":"shape","width":575,"height":368,"scale":100,"focalX":50,"focalY":50,"mask":{"type":"rectangle"},"groupId":null,"id":"32431722-a962-4a78-b7b9-ceb62b7c2245"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Darker Grotesque","fallbacks":["sans-serif"],"weights":[300,400,500,600,700,800,900],"styles":["regular"],"variants":[[0,300],[0,400],[0,500],[0,600],[0,700],[0,800],[0,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1060,"des":-296,"tAsc":1060,"tDes":-296,"tLGap":0,"wAsc":1060,"wDes":296,"xH":406,"capH":563,"yMin":-296,"yMax":1060,"hAsc":1060,"hDes":-296,"lGap":0}},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":0.9,"textAlign":"initial","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"color: #fff\">A central repository where raw data is transformed and stored in a queryable format. It includes commutative and historical data from single or multiple sources.<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":33,"y":307,"width":350,"height":176,"scale":100,"focalX":50,"focalY":50,"type":"text","tagName":"p","basedOn":"398f52b4-9c0e-4bd5-b4c0-5a83c06ad4bc","id":"e7c1e468-0b2f-424a-a0ce-637c4d6f0af8"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto","fallbacks":["sans-serif"],"weights":[100,300,400,500,700,900],"styles":["italic","regular"],"variants":[[0,100],[1,100],[0,300],[1,300],[0,400],[1,400],[0,500],[1,500],[0,700],[1,700],[0,900],[1,900]],"service":"fonts.google.com","metrics":{"upm":2048,"asc":1900,"des":-500,"tAsc":1536,"tDes":-512,"tLGap":102,"wAsc":1946,"wDes":512,"xH":1082,"capH":1456,"yMin":-555,"yMax":2163,"hAsc":1900,"hDes":-500,"lGap":0}},"fontSize":35,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"type":"text","content":"<span style=\"font-weight: 700; color: #fff\">Introduction to Data Warehouse<\/span>","borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":25,"y":96,"width":366,"height":82,"scale":100,"focalX":50,"focalY":50,"id":"6e9d2941-9828-4fb0-9659-31fedc6f84fc"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":-3,"y":-40,"width":180,"height":60,"mask":{"type":"rectangle"},"type":"image","scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","creationDate":"2021-07-12T14:57:03","src":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png","width":2130,"height":708,"id":724,"alt":"InterviewBit-White-2","sizes":{"medium":{"file":"InterviewBit-White-2-300x100.png","width":300,"height":100,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png"},"large":{"file":"InterviewBit-White-2-1024x340.png","width":1024,"height":340,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png"},"thumbnail":{"file":"InterviewBit-White-2-150x150.png","width":150,"height":150,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x150.png"},"medium_large":{"file":"InterviewBit-White-2-768x255.png","width":768,"height":255,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png"},"1536x1536":{"file":"InterviewBit-White-2-1536x511.png","width":1536,"height":511,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png"},"2048x2048":{"file":"InterviewBit-White-2-2048x681.png","width":2048,"height":681,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png"},"web-stories-poster-portrait":{"file":"InterviewBit-White-2-640x708.png","width":640,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x708.png"},"web-stories-poster-landscape":{"file":"InterviewBit-White-2-853x640.png","width":853,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-853x640.png"},"web-stories-poster-square":{"file":"InterviewBit-White-2-640x640.png","width":640,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x640.png"},"web-stories-publisher-logo":{"file":"InterviewBit-White-2-96x96.png","width":96,"height":96,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-96x96.png"},"web-stories-thumbnail":{"file":"InterviewBit-White-2-150x50.png","width":150,"height":50,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png"},"full":{"file":"InterviewBit-White-2.png","width":2130,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png"}},"isOptimized":false,"isExternal":false},"basedOn":"ea251a16-bb73-4d60-8d67-8b48c3a5f099","id":"6cc1faa7-56dc-433b-8519-79268c4850b9"}],"animations":[{"id":"99925c01-1ed8-48ec-b2c1-d0f333a138fb","type":"effect-fly-in","flyInDir":"topToBottom","duration":600,"delay":0,"targets":["e7c1e468-0b2f-424a-a0ce-637c4d6f0af8"]},{"id":"b2c57a37-f882-47b3-9fe8-ad5edf60d4e3","type":"effect-fly-in","flyInDir":"topToBottom","duration":600,"delay":0,"targets":["6e9d2941-9828-4fb0-9659-31fedc6f84fc"]},{"id":"cd4400cb-ef15-4ab0-8245-c6eefa623ce1","type":"effect-background-pan-and-zoom","panDir":"rightToLeft","duration":2000,"delay":0,"zoomDirection":"scaleOut","targets":["45edd8cc-1669-4671-acd2-9562350a0232"]}],"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"type":"page","id":"f4981294-aa5d-488c-8a6c-880eb6a310bc","pageTemplateType":"cover","groups":{"43822f2d-e2ce-445d-ac82-13372d91db61":{"name":"Background","isLocked":true,"isCollapsed":true}},"defaultBackgroundElement":{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"3759940d-5b3d-42ff-ab66-314e5eedf126","basedOn":"8fe4f619-7591-4389-b43e-d196bd3f5eb1"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/components-of-data-warehouse\/?utm_source=Ib&utm_medium=components-of-data-warehouse&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/Components-of-Data-Warehouse-1-2048x1000.png","needsProxy":false,"ctaText":"Read More"}},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":48,"y":0,"width":330,"height":494,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"7cf9d1d8-3d90-467c-8891-d45926c8b211","basedOn":"8fe4f619-7591-4389-b43e-d196bd3f5eb1","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#f3f3f3","blurHash":"LeH2Zc00t6kC-:t7M{kCR*o2t6t7","type":"image","mimeType":"image\/jpeg","creationDate":"2019-07-19T11:41:39Z","src":"https:\/\/images.unsplash.com\/flagged\/photo-1563536310477-c7b4e3a800c2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1N3x8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzMzM&ixlib=rb-1.2.1&fm=jpg&w=4000&h=6000&fit=max","width":4000,"height":6000,"id":"media\/unsplash:NdFREMS5P08","alt":"woman leaning at the table","sizes":{"full":{"file":"media\/unsplash:NdFREMS5P08","sourceUrl":"https:\/\/images.unsplash.com\/flagged\/photo-1563536310477-c7b4e3a800c2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1N3x8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzMzM&ixlib=rb-1.2.1&fm=jpg&w=4000&h=6000&fit=max","mimeType":"image\/jpeg","width":4000,"height":6000},"large":{"file":"media\/unsplash:NdFREMS5P08","sourceUrl":"https:\/\/images.unsplash.com\/flagged\/photo-1563536310477-c7b4e3a800c2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1N3x8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzMzM&ixlib=rb-1.2.1&fm=jpg&w=3200&h=4800&fit=max","mimeType":"image\/jpeg","width":3200,"height":4800},"2400_3600":{"file":"media\/unsplash:NdFREMS5P08","sourceUrl":"https:\/\/images.unsplash.com\/flagged\/photo-1563536310477-c7b4e3a800c2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1N3x8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzMzM&ixlib=rb-1.2.1&fm=jpg&w=2400&h=3600&fit=max","mimeType":"image\/jpeg","width":2400,"height":3600},"1600_2400":{"file":"media\/unsplash:NdFREMS5P08","sourceUrl":"https:\/\/images.unsplash.com\/flagged\/photo-1563536310477-c7b4e3a800c2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1N3x8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzMzM&ixlib=rb-1.2.1&fm=jpg&w=1600&h=2400&fit=max","mimeType":"image\/jpeg","width":1600,"height":2400},"800_1200":{"file":"media\/unsplash:NdFREMS5P08","sourceUrl":"https:\/\/images.unsplash.com\/flagged\/photo-1563536310477-c7b4e3a800c2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1N3x8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzMzM&ixlib=rb-1.2.1&fm=jpg&w=800&h=1200&fit=max","mimeType":"image\/jpeg","width":800,"height":1200},"web_stories_thumbnail":{"file":"media\/unsplash:NdFREMS5P08","sourceUrl":"https:\/\/images.unsplash.com\/flagged\/photo-1563536310477-c7b4e3a800c2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1N3x8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzMzM&ixlib=rb-1.2.1&fm=jpg&w=340&h=510&fit=max","mimeType":"image\/jpeg","width":340,"height":510}},"attribution":{"author":{"displayName":"Nicole Wolf","url":"https:\/\/unsplash.com\/@joeel56?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4tpY2%2BUTP6YwjFpDaBiJc6fD9BN3t\/SN\/\/isMJsEmXSQBJ60Owi\/\/VGvUChr31tFJUc7HhUxUsKUi8kEq%2BgJFXy4%2BEmVF4s\/4vWvJGGnpAR8N%2BaLww0IEd0Lvx52pLKgOrLgpLtMNZVI3M8\/oZQD2pG6iyCTZSkt0H8tJqiopY5QSPWfXFf\/wZRXqSuvXREdghPw2MdZC6rJMeQ4uVFqDSwY2wqjVUc%2BWI5XeI5XCHz9cdHh"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.5}}},{"x":-57,"y":246,"basedOn":"e564704d-ee72-4d2a-b3f2-522089917dca","opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":10,"lockAspectRatio":false,"backgroundColor":{"color":{"r":201,"g":24,"b":74,"a":0.5}},"type":"shape","width":575,"height":368,"scale":100,"focalX":50,"focalY":50,"mask":{"type":"rectangle"},"groupId":null,"id":"7aebd8ed-b1ba-4a77-90fb-48099ace3441"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Darker Grotesque","fallbacks":["sans-serif"],"weights":[300,400,500,600,700,800,900],"styles":["regular"],"variants":[[0,300],[0,400],[0,500],[0,600],[0,700],[0,800],[0,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1060,"des":-296,"tAsc":1060,"tDes":-296,"tLGap":0,"wAsc":1060,"wDes":296,"xH":406,"capH":563,"yMin":-296,"yMax":1060,"hAsc":1060,"hDes":-296,"lGap":0}},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":0.9,"textAlign":"initial","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #fff\">1. Data Warehouse Database&nbsp;<\/span>\n\n<span style=\"color: #fff\">A database stores all company data and makes it manageable to report. Database types can be relational, analytical, cloud-based, or data warehouse applications.<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":26,"y":319,"width":358,"height":203,"scale":100,"focalX":50,"focalY":50,"type":"text","tagName":"p","basedOn":"e7c1e468-0b2f-424a-a0ce-637c4d6f0af8","id":"89e0b125-ab89-4efb-bf13-d9d129cc75e2"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":-3,"y":-40,"width":180,"height":60,"mask":{"type":"rectangle"},"type":"image","scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","creationDate":"2021-07-12T14:57:03","src":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png","width":2130,"height":708,"id":724,"alt":"InterviewBit-White-2","sizes":{"medium":{"file":"InterviewBit-White-2-300x100.png","width":300,"height":100,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png"},"large":{"file":"InterviewBit-White-2-1024x340.png","width":1024,"height":340,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png"},"thumbnail":{"file":"InterviewBit-White-2-150x150.png","width":150,"height":150,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x150.png"},"medium_large":{"file":"InterviewBit-White-2-768x255.png","width":768,"height":255,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png"},"1536x1536":{"file":"InterviewBit-White-2-1536x511.png","width":1536,"height":511,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png"},"2048x2048":{"file":"InterviewBit-White-2-2048x681.png","width":2048,"height":681,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png"},"web-stories-poster-portrait":{"file":"InterviewBit-White-2-640x708.png","width":640,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x708.png"},"web-stories-poster-landscape":{"file":"InterviewBit-White-2-853x640.png","width":853,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-853x640.png"},"web-stories-poster-square":{"file":"InterviewBit-White-2-640x640.png","width":640,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x640.png"},"web-stories-publisher-logo":{"file":"InterviewBit-White-2-96x96.png","width":96,"height":96,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-96x96.png"},"web-stories-thumbnail":{"file":"InterviewBit-White-2-150x50.png","width":150,"height":50,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png"},"full":{"file":"InterviewBit-White-2.png","width":2130,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png"}},"isOptimized":false,"isExternal":false},"basedOn":"ea251a16-bb73-4d60-8d67-8b48c3a5f099","id":"02b12203-ca5e-46c5-a6b5-5d807cb104c2"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto","fallbacks":["sans-serif"],"weights":[100,300,400,500,700,900],"styles":["italic","regular"],"variants":[[0,100],[1,100],[0,300],[1,300],[0,400],[1,400],[0,500],[1,500],[0,700],[1,700],[0,900],[1,900]],"service":"fonts.google.com","metrics":{"upm":2048,"asc":1900,"des":-500,"tAsc":1536,"tDes":-512,"tLGap":102,"wAsc":1946,"wDes":512,"xH":1082,"capH":1456,"yMin":-555,"yMax":2163,"hAsc":1900,"hDes":-500,"lGap":0}},"fontSize":35,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"type":"text","content":"<span style=\"font-weight: 700; color: #fff\">Components of Data Warehouse<\/span>","borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":32,"y":113,"width":366,"height":82,"scale":100,"focalX":50,"focalY":50,"basedOn":"6e9d2941-9828-4fb0-9659-31fedc6f84fc","id":"221deb50-fa6c-4eea-aff1-08b86e2e7e7d"}],"animations":[{"id":"377a572a-a664-4534-a723-40cfb9e47132","type":"effect-fly-in","flyInDir":"topToBottom","duration":600,"delay":0,"targets":["89e0b125-ab89-4efb-bf13-d9d129cc75e2"]},{"id":"5887dfa8-7679-4046-88c1-36432d5520ee","type":"effect-background-pan-and-zoom","panDir":"rightToLeft","duration":2000,"delay":0,"zoomDirection":"scaleOut","targets":["7cf9d1d8-3d90-467c-8891-d45926c8b211"]},{"targets":["221deb50-fa6c-4eea-aff1-08b86e2e7e7d"],"id":"2ae918d4-53f0-47e8-9703-be46226c0517","type":"effect-fly-in","flyInDir":"topToBottom","duration":600,"delay":0}],"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"type":"page","id":"7475a312-090b-4904-a1e7-c092b5a9d208","pageTemplateType":"cover","groups":{"43822f2d-e2ce-445d-ac82-13372d91db61":{"name":"Background","isLocked":true,"isCollapsed":true}},"defaultBackgroundElement":{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"1467c837-f423-4c93-bd25-6513bd74a2da","basedOn":"8fe4f619-7591-4389-b43e-d196bd3f5eb1"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/components-of-data-warehouse\/?utm_source=Ib&utm_medium=components-of-data-warehouse&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/Components-of-Data-Warehouse-1-2048x1000.png","needsProxy":false,"ctaText":"Read More"}},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":48,"y":0,"width":330,"height":506,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"048aa9e4-e712-4700-a606-585ab62d5d29","basedOn":"8fe4f619-7591-4389-b43e-d196bd3f5eb1","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#d9d9c0","blurHash":"LOLW*55R9F8_?^DiDjoz9tMxt7WY","type":"image","mimeType":"image\/jpeg","creationDate":"2021-03-26T06:45:59Z","src":"https:\/\/images.unsplash.com\/photo-1616740793717-0aca29b92221?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNHx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&ixlib=rb-1.2.1&fm=jpg&w=3466&h=5318&fit=max","width":3466,"height":5318,"id":"media\/unsplash:2THdTdKs0yU","alt":"woman in red blazer holding white paper","sizes":{"full":{"file":"media\/unsplash:2THdTdKs0yU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1616740793717-0aca29b92221?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNHx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&ixlib=rb-1.2.1&fm=jpg&w=3466&h=5318&fit=max","mimeType":"image\/jpeg","width":3466,"height":5318},"large":{"file":"media\/unsplash:2THdTdKs0yU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1616740793717-0aca29b92221?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNHx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&ixlib=rb-1.2.1&fm=jpg&w=2772&h=4253&fit=max","mimeType":"image\/jpeg","width":2772,"height":4253},"2079_3190":{"file":"media\/unsplash:2THdTdKs0yU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1616740793717-0aca29b92221?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNHx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&ixlib=rb-1.2.1&fm=jpg&w=2079&h=3190&fit=max","mimeType":"image\/jpeg","width":2079,"height":3190},"1386_2127":{"file":"media\/unsplash:2THdTdKs0yU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1616740793717-0aca29b92221?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNHx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&ixlib=rb-1.2.1&fm=jpg&w=1386&h=2127&fit=max","mimeType":"image\/jpeg","width":1386,"height":2127},"693_1063":{"file":"media\/unsplash:2THdTdKs0yU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1616740793717-0aca29b92221?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNHx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&ixlib=rb-1.2.1&fm=jpg&w=693&h=1063&fit=max","mimeType":"image\/jpeg","width":693,"height":1063},"web_stories_thumbnail":{"file":"media\/unsplash:2THdTdKs0yU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1616740793717-0aca29b92221?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzNHx8cmVzdW1lfGVufDB8fHx8MTY2NTUwMTA1NA&ixlib=rb-1.2.1&fm=jpg&w=340&h=522&fit=max","mimeType":"image\/jpeg","width":340,"height":522}},"attribution":{"author":{"displayName":"Kateryna Hliznitsova","url":"https:\/\/unsplash.com\/@kate_gliz?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4tpKhsZ8sYAgAsLOPi\/kI5qytduNaepgE\/oYJebds\/gTlt7utYPn9kGNjsovTzj8ZRjL9hoKpwqj0oNtt1LRBYVdw7kvE1Ak3J4qmdKPXFwj5hBrE7PwnfTf62f2ZTA8PThkYzrRUz12ckdwb5g9EyKklpFLpaN3mHGGSIlupFs4sGQfdb6OHSVfm9\/4ppWUQSSOm2%2BD5sgymw3ZH7zq%2BNunl1IoFanrHnlk7mtVXQ%3D%3D"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.5}}},{"x":-57,"y":246,"basedOn":"e564704d-ee72-4d2a-b3f2-522089917dca","opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":10,"lockAspectRatio":false,"backgroundColor":{"color":{"r":201,"g":24,"b":74,"a":0.5}},"type":"shape","width":575,"height":368,"scale":100,"focalX":50,"focalY":50,"mask":{"type":"rectangle"},"groupId":null,"id":"41a0e586-58a3-43b7-a176-5ab26a7b4b8d"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Darker Grotesque","fallbacks":["sans-serif"],"weights":[300,400,500,600,700,800,900],"styles":["regular"],"variants":[[0,300],[0,400],[0,500],[0,600],[0,700],[0,800],[0,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1060,"des":-296,"tAsc":1060,"tDes":-296,"tLGap":0,"wAsc":1060,"wDes":296,"xH":406,"capH":563,"yMin":-296,"yMax":1060,"hAsc":1060,"hDes":-296,"lGap":0}},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":0.9,"textAlign":"initial","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #fff\">2. Sourcing, Acquisition, Cleanup, and Transformation Tools (ETL)<\/span>\n\n<span style=\"color: #fff\">The tool performs all summarizations, conversions, structural changes, key changes, and condensations required to convert disparate data into decision support data.<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":34,"y":264,"width":368,"height":284,"scale":100,"focalX":50,"focalY":50,"type":"text","tagName":"p","basedOn":"89e0b125-ab89-4efb-bf13-d9d129cc75e2","id":"d7e796ac-1eee-4deb-930d-464ae64fed1d"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":-3,"y":-40,"width":180,"height":60,"mask":{"type":"rectangle"},"type":"image","scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","creationDate":"2021-07-12T14:57:03","src":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png","width":2130,"height":708,"id":724,"alt":"InterviewBit-White-2","sizes":{"medium":{"file":"InterviewBit-White-2-300x100.png","width":300,"height":100,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png"},"large":{"file":"InterviewBit-White-2-1024x340.png","width":1024,"height":340,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png"},"thumbnail":{"file":"InterviewBit-White-2-150x150.png","width":150,"height":150,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x150.png"},"medium_large":{"file":"InterviewBit-White-2-768x255.png","width":768,"height":255,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png"},"1536x1536":{"file":"InterviewBit-White-2-1536x511.png","width":1536,"height":511,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png"},"2048x2048":{"file":"InterviewBit-White-2-2048x681.png","width":2048,"height":681,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png"},"web-stories-poster-portrait":{"file":"InterviewBit-White-2-640x708.png","width":640,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x708.png"},"web-stories-poster-landscape":{"file":"InterviewBit-White-2-853x640.png","width":853,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-853x640.png"},"web-stories-poster-square":{"file":"InterviewBit-White-2-640x640.png","width":640,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x640.png"},"web-stories-publisher-logo":{"file":"InterviewBit-White-2-96x96.png","width":96,"height":96,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-96x96.png"},"web-stories-thumbnail":{"file":"InterviewBit-White-2-150x50.png","width":150,"height":50,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png"},"full":{"file":"InterviewBit-White-2.png","width":2130,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png"}},"isOptimized":false,"isExternal":false},"basedOn":"ea251a16-bb73-4d60-8d67-8b48c3a5f099","id":"6bd2e494-0066-4b59-8260-9658bd46986e"}],"animations":[{"id":"01dc32e3-7c59-4911-8ede-448785bf617e","type":"effect-fly-in","flyInDir":"topToBottom","duration":600,"delay":0,"targets":["d7e796ac-1eee-4deb-930d-464ae64fed1d"]},{"targets":["048aa9e4-e712-4700-a606-585ab62d5d29"],"id":"e87920a3-0e51-4edb-a3cd-87828698682c","type":"effect-background-pan-and-zoom","panDir":"rightToLeft","duration":2000,"delay":0,"zoomDirection":"scaleOut"}],"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"type":"page","id":"cd57867d-e34a-4b0c-af12-ad492d46f078","pageTemplateType":"cover","groups":{"43822f2d-e2ce-445d-ac82-13372d91db61":{"name":"Background","isLocked":true,"isCollapsed":true}},"defaultBackgroundElement":{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"b20a357f-cf84-44b9-a6df-1b29dcf90cd7","basedOn":"8fe4f619-7591-4389-b43e-d196bd3f5eb1"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/components-of-data-warehouse\/?utm_source=Ib&utm_medium=components-of-data-warehouse&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/Components-of-Data-Warehouse-1-2048x1000.png","needsProxy":false,"ctaText":"Read More"}},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":48,"y":0,"width":330,"height":494,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"e7faba9e-a9a1-4f05-819d-72f2dffc8df2","basedOn":"8fe4f619-7591-4389-b43e-d196bd3f5eb1","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#f3f3f3","blurHash":"LlH.QcIAxut7~qayt7xu?bt7M{xv","type":"image","mimeType":"image\/jpeg","creationDate":"2019-11-11T18:11:53Z","src":"https:\/\/images.unsplash.com\/photo-1573495783323-9e59a325d4b4?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3MHx8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzNjE&ixlib=rb-1.2.1&fm=jpg&w=4016&h=6016&fit=max","width":4016,"height":6016,"id":"media\/unsplash:7RRj4wDX7LE","alt":"shallow focus photo of woman using MacBook","sizes":{"full":{"file":"media\/unsplash:7RRj4wDX7LE","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573495783323-9e59a325d4b4?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3MHx8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzNjE&ixlib=rb-1.2.1&fm=jpg&w=4016&h=6016&fit=max","mimeType":"image\/jpeg","width":4016,"height":6016},"large":{"file":"media\/unsplash:7RRj4wDX7LE","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573495783323-9e59a325d4b4?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3MHx8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzNjE&ixlib=rb-1.2.1&fm=jpg&w=3212&h=4812&fit=max","mimeType":"image\/jpeg","width":3212,"height":4812},"2409_3609":{"file":"media\/unsplash:7RRj4wDX7LE","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573495783323-9e59a325d4b4?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3MHx8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzNjE&ixlib=rb-1.2.1&fm=jpg&w=2409&h=3609&fit=max","mimeType":"image\/jpeg","width":2409,"height":3609},"1606_2406":{"file":"media\/unsplash:7RRj4wDX7LE","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573495783323-9e59a325d4b4?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3MHx8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzNjE&ixlib=rb-1.2.1&fm=jpg&w=1606&h=2406&fit=max","mimeType":"image\/jpeg","width":1606,"height":2406},"803_1203":{"file":"media\/unsplash:7RRj4wDX7LE","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573495783323-9e59a325d4b4?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3MHx8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzNjE&ixlib=rb-1.2.1&fm=jpg&w=803&h=1203&fit=max","mimeType":"image\/jpeg","width":803,"height":1203},"web_stories_thumbnail":{"file":"media\/unsplash:7RRj4wDX7LE","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573495783323-9e59a325d4b4?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3MHx8ZGV2ZWxvcGVyc3xlbnwwfHx8fDE2NjQ0NjYzNjE&ixlib=rb-1.2.1&fm=jpg&w=340&h=509&fit=max","mimeType":"image\/jpeg","width":340,"height":509}},"attribution":{"author":{"displayName":"Christina @ wocintechchat.com","url":"https:\/\/unsplash.com\/@wocintechchat?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4tqCqy1VrA\/87Yw3PZrAhYUH9prxWhFxKYzgdgwwbBc2sKEhWj1KqeYYnpwtpfNLRUmN85o29gdyzJhA0ziDin13VcYXiyHJF77LNsqROK88a%2BysiA%2BErvBQxWGn14exo0ZlthVJjYYEjSDCPyLrtGYqaFzzQ1LFOfSCwLNVWZan\/JTQZeFCYRA2AjAuR%2BzlyieLBo2n4SyKTzcyUs3b%2B7m1EX3Fwj%2BJTnx\/DOYwEe064phd"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.5}}},{"x":-57,"y":246,"basedOn":"cf64920e-fd91-4c46-82db-a6825870e4fc","opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":10,"lockAspectRatio":false,"backgroundColor":{"color":{"r":201,"g":24,"b":74,"a":0.5}},"type":"shape","width":575,"height":368,"scale":100,"focalX":50,"focalY":50,"mask":{"type":"rectangle"},"groupId":null,"id":"e564704d-ee72-4d2a-b3f2-522089917dca"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Darker Grotesque","fallbacks":["sans-serif"],"weights":[300,400,500,600,700,800,900],"styles":["regular"],"variants":[[0,300],[0,400],[0,500],[0,600],[0,700],[0,800],[0,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1060,"des":-296,"tAsc":1060,"tDes":-296,"tLGap":0,"wAsc":1060,"wDes":296,"xH":406,"capH":563,"yMin":-296,"yMax":1060,"hAsc":1060,"hDes":-296,"lGap":0}},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":0.9,"textAlign":"initial","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #fff\">3. Metadata<\/span><span style=\"color: #fff\">&nbsp;<\/span>\n\n<span style=\"color: #fff\">Metadata serves as a framework for data in the data warehouse architecture. Assists in handling, maintaining, constructing, and utilizing data warehouses.<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":33,"y":295,"width":353,"height":229,"scale":100,"focalX":50,"focalY":50,"type":"text","tagName":"p","basedOn":"d7e796ac-1eee-4deb-930d-464ae64fed1d","id":"d7950025-27d2-4422-aa84-506fcb59ffca"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":-3,"y":-40,"width":180,"height":60,"mask":{"type":"rectangle"},"type":"image","scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","creationDate":"2021-07-12T14:57:03","src":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png","width":2130,"height":708,"id":724,"alt":"InterviewBit-White-2","sizes":{"medium":{"file":"InterviewBit-White-2-300x100.png","width":300,"height":100,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png"},"large":{"file":"InterviewBit-White-2-1024x340.png","width":1024,"height":340,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png"},"thumbnail":{"file":"InterviewBit-White-2-150x150.png","width":150,"height":150,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x150.png"},"medium_large":{"file":"InterviewBit-White-2-768x255.png","width":768,"height":255,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png"},"1536x1536":{"file":"InterviewBit-White-2-1536x511.png","width":1536,"height":511,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png"},"2048x2048":{"file":"InterviewBit-White-2-2048x681.png","width":2048,"height":681,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png"},"web-stories-poster-portrait":{"file":"InterviewBit-White-2-640x708.png","width":640,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x708.png"},"web-stories-poster-landscape":{"file":"InterviewBit-White-2-853x640.png","width":853,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-853x640.png"},"web-stories-poster-square":{"file":"InterviewBit-White-2-640x640.png","width":640,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x640.png"},"web-stories-publisher-logo":{"file":"InterviewBit-White-2-96x96.png","width":96,"height":96,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-96x96.png"},"web-stories-thumbnail":{"file":"InterviewBit-White-2-150x50.png","width":150,"height":50,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png"},"full":{"file":"InterviewBit-White-2.png","width":2130,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png"}},"isOptimized":false,"isExternal":false},"basedOn":"ea251a16-bb73-4d60-8d67-8b48c3a5f099","id":"5339da21-7a91-4913-9d78-9538a6c595fd"}],"animations":[{"id":"5def4fca-2ce4-4163-b492-bb85c0633b14","type":"effect-fly-in","flyInDir":"topToBottom","duration":600,"delay":0,"targets":["d7950025-27d2-4422-aa84-506fcb59ffca"]},{"id":"5a8ee6f3-7e16-4a6a-b26c-d8d97a1c6c3e","type":"effect-background-pan-and-zoom","panDir":"rightToLeft","duration":2000,"delay":0,"zoomDirection":"scaleOut","targets":["e7faba9e-a9a1-4f05-819d-72f2dffc8df2"]}],"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"type":"page","id":"31fdfdff-2dbc-4ebb-8700-095521d60841","pageTemplateType":"cover","groups":{"43822f2d-e2ce-445d-ac82-13372d91db61":{"name":"Background","isLocked":true,"isCollapsed":true}},"defaultBackgroundElement":{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"f35b4618-d680-4765-b972-9b65a643b5b0","basedOn":"8fe4f619-7591-4389-b43e-d196bd3f5eb1"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/components-of-data-warehouse\/?utm_source=Ib&utm_medium=components-of-data-warehouse&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/Components-of-Data-Warehouse-1-2048x1000.png","needsProxy":false,"ctaText":"Read More"}},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":48,"y":0,"width":330,"height":220,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"f35b4618-d680-4765-b972-9b65a643b5b0","basedOn":"8fe4f619-7591-4389-b43e-d196bd3f5eb1","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#f3f3f3","blurHash":"LjK1zh4Tabxv_3t6RjM{-oj[M|Ri","type":"image","mimeType":"image\/jpeg","creationDate":"2020-03-06T15:36:28Z","src":"https:\/\/images.unsplash.com\/photo-1583508915901-b5f84c1dcde1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTEw&ixlib=rb-4.0.3&fm=jpg&w=6000&h=4000&fit=max","width":6000,"height":4000,"id":"media\/unsplash:B6JINerWMz0","alt":"man in gray dress shirt sitting on chair in front of computer monitor","sizes":{"full":{"file":"media\/unsplash:B6JINerWMz0","sourceUrl":"https:\/\/images.unsplash.com\/photo-1583508915901-b5f84c1dcde1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTEw&ixlib=rb-4.0.3&fm=jpg&w=6000&h=4000&fit=max","mimeType":"image\/jpeg","width":6000,"height":4000},"large":{"file":"media\/unsplash:B6JINerWMz0","sourceUrl":"https:\/\/images.unsplash.com\/photo-1583508915901-b5f84c1dcde1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTEw&ixlib=rb-4.0.3&fm=jpg&w=4800&h=3200&fit=max","mimeType":"image\/jpeg","width":4800,"height":3200},"3600_2400":{"file":"media\/unsplash:B6JINerWMz0","sourceUrl":"https:\/\/images.unsplash.com\/photo-1583508915901-b5f84c1dcde1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTEw&ixlib=rb-4.0.3&fm=jpg&w=3600&h=2400&fit=max","mimeType":"image\/jpeg","width":3600,"height":2400},"2400_1600":{"file":"media\/unsplash:B6JINerWMz0","sourceUrl":"https:\/\/images.unsplash.com\/photo-1583508915901-b5f84c1dcde1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTEw&ixlib=rb-4.0.3&fm=jpg&w=2400&h=1600&fit=max","mimeType":"image\/jpeg","width":2400,"height":1600},"1200_800":{"file":"media\/unsplash:B6JINerWMz0","sourceUrl":"https:\/\/images.unsplash.com\/photo-1583508915901-b5f84c1dcde1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTEw&ixlib=rb-4.0.3&fm=jpg&w=1200&h=800&fit=max","mimeType":"image\/jpeg","width":1200,"height":800},"web_stories_thumbnail":{"file":"media\/unsplash:B6JINerWMz0","sourceUrl":"https:\/\/images.unsplash.com\/photo-1583508915901-b5f84c1dcde1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxNXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTEw&ixlib=rb-4.0.3&fm=jpg&w=340&h=227&fit=max","mimeType":"image\/jpeg","width":340,"height":227}},"attribution":{"author":{"displayName":"Luke Peters","url":"https:\/\/unsplash.com\/@lukepeters?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AWJwhCH0ZxItFye4tsgzln8wQelyHh9tMqdJ98326hqk%2BXh4Avg5Vj5x8sfdMUC0mEOxDr40mydTsLfXVTaIALo%2Bvhx7SDujX79aMfW03YzNdu31ssffl\/LlnOO1T%2Bz4DZNnOQPgn8WOOwJ2fyCkSxK4o0sVk8%2BXfbjQM61CIeugGXUMkW7GXfU4O93RabBoHp\/VnMEatzZhZrSFJ%2BjwCwNZ7LCdqrRRCTp\/dQUaktUpnXzrAVsfL67Rg5Ut%2BvfyCET%2BTg%3D%3D"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.5}}},{"x":-57,"y":246,"basedOn":"e564704d-ee72-4d2a-b3f2-522089917dca","opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":10,"lockAspectRatio":false,"backgroundColor":{"color":{"r":201,"g":24,"b":74,"a":0.5}},"type":"shape","width":575,"height":368,"scale":100,"focalX":50,"focalY":50,"mask":{"type":"rectangle"},"groupId":null,"id":"0436c217-eff4-400f-b5f3-0f7b3ba97871"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Darker Grotesque","fallbacks":["sans-serif"],"weights":[300,400,500,600,700,800,900],"styles":["regular"],"variants":[[0,300],[0,400],[0,500],[0,600],[0,700],[0,800],[0,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1060,"des":-296,"tAsc":1060,"tDes":-296,"tLGap":0,"wAsc":1060,"wDes":296,"xH":406,"capH":563,"yMin":-296,"yMax":1060,"hAsc":1060,"hDes":-296,"lGap":0}},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":0.9,"textAlign":"initial","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #fff\">4. Query Tools&nbsp;<\/span>\n\n<span style=\"color: #fff\">With query tools, you can access data and the database catalog, create and implement SQL queries, and manage database objects and database users.<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":36,"y":292,"width":350,"height":229,"scale":100,"focalX":50,"focalY":50,"type":"text","tagName":"p","basedOn":"d7950025-27d2-4422-aa84-506fcb59ffca","id":"7cbe63a3-d2a9-44ee-9294-63419067274d"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":-3,"y":-40,"width":180,"height":60,"mask":{"type":"rectangle"},"type":"image","scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","creationDate":"2021-07-12T14:57:03","src":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png","width":2130,"height":708,"id":724,"alt":"InterviewBit-White-2","sizes":{"medium":{"file":"InterviewBit-White-2-300x100.png","width":300,"height":100,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png"},"large":{"file":"InterviewBit-White-2-1024x340.png","width":1024,"height":340,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png"},"thumbnail":{"file":"InterviewBit-White-2-150x150.png","width":150,"height":150,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x150.png"},"medium_large":{"file":"InterviewBit-White-2-768x255.png","width":768,"height":255,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png"},"1536x1536":{"file":"InterviewBit-White-2-1536x511.png","width":1536,"height":511,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png"},"2048x2048":{"file":"InterviewBit-White-2-2048x681.png","width":2048,"height":681,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png"},"web-stories-poster-portrait":{"file":"InterviewBit-White-2-640x708.png","width":640,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x708.png"},"web-stories-poster-landscape":{"file":"InterviewBit-White-2-853x640.png","width":853,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-853x640.png"},"web-stories-poster-square":{"file":"InterviewBit-White-2-640x640.png","width":640,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x640.png"},"web-stories-publisher-logo":{"file":"InterviewBit-White-2-96x96.png","width":96,"height":96,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-96x96.png"},"web-stories-thumbnail":{"file":"InterviewBit-White-2-150x50.png","width":150,"height":50,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png"},"full":{"file":"InterviewBit-White-2.png","width":2130,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png"}},"isOptimized":false,"isExternal":false},"basedOn":"5339da21-7a91-4913-9d78-9538a6c595fd","id":"11905f15-a6e1-4923-b588-85de48a1dac6"}],"animations":[{"id":"7cf7eda5-2bb7-404b-b6d3-cf30cb94496f","type":"effect-fly-in","flyInDir":"topToBottom","duration":600,"delay":0,"targets":["7cbe63a3-d2a9-44ee-9294-63419067274d"]},{"id":"62a56368-a7a0-454b-b4df-b77f67658d8b","type":"effect-background-pan-and-zoom","panDir":"rightToLeft","duration":2000,"delay":0,"zoomDirection":"scaleOut","targets":["f35b4618-d680-4765-b972-9b65a643b5b0"]}],"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"type":"page","id":"c5932a30-dcd5-4c37-bf3b-7ce1e2efa63e","pageTemplateType":"cover","groups":{"43822f2d-e2ce-445d-ac82-13372d91db61":{"name":"Background","isLocked":true,"isCollapsed":true}},"defaultBackgroundElement":{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"95d19bfb-4958-4efb-b279-2cb823a4e742","basedOn":"8fe4f619-7591-4389-b43e-d196bd3f5eb1"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/components-of-data-warehouse\/?utm_source=Ib&utm_medium=components-of-data-warehouse&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/Components-of-Data-Warehouse-1-2048x1000.png","needsProxy":false,"ctaText":"Read More"}},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":57,"y":278,"width":330,"height":494,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"f35b4618-d680-4765-b972-9b65a643b5b0","basedOn":"8fe4f619-7591-4389-b43e-d196bd3f5eb1","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#c0d9c0","blurHash":"LOGbxBXA0LM{9G%1ocR*GGRk?Hof","type":"image","mimeType":"image\/jpeg","creationDate":"2020-02-05T09:34:15Z","src":"https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2MHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTUz&ixlib=rb-4.0.3&fm=jpg&w=5304&h=7952&fit=max","width":5304,"height":7952,"id":"media\/unsplash:lLrZy195sIU","alt":"man in pink button up shirt sitting beside woman in blue and black shirt","sizes":{"full":{"file":"media\/unsplash:lLrZy195sIU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2MHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTUz&ixlib=rb-4.0.3&fm=jpg&w=5304&h=7952&fit=max","mimeType":"image\/jpeg","width":5304,"height":7952},"large":{"file":"media\/unsplash:lLrZy195sIU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2MHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTUz&ixlib=rb-4.0.3&fm=jpg&w=4243&h=6361&fit=max","mimeType":"image\/jpeg","width":4243,"height":6361},"3182_4771":{"file":"media\/unsplash:lLrZy195sIU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2MHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTUz&ixlib=rb-4.0.3&fm=jpg&w=3182&h=4771&fit=max","mimeType":"image\/jpeg","width":3182,"height":4771},"2121_3180":{"file":"media\/unsplash:lLrZy195sIU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2MHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTUz&ixlib=rb-4.0.3&fm=jpg&w=2121&h=3180&fit=max","mimeType":"image\/jpeg","width":2121,"height":3180},"1060_1589":{"file":"media\/unsplash:lLrZy195sIU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2MHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTUz&ixlib=rb-4.0.3&fm=jpg&w=1060&h=1589&fit=max","mimeType":"image\/jpeg","width":1060,"height":1589},"web_stories_thumbnail":{"file":"media\/unsplash:lLrZy195sIU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw2MHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NTE3MTUz&ixlib=rb-4.0.3&fm=jpg&w=340&h=510&fit=max","mimeType":"image\/jpeg","width":340,"height":510}},"attribution":{"author":{"displayName":"ThisisEngineering RAEng","url":"https:\/\/unsplash.com\/@thisisengineering?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AWJwhCEFHBUKqn\/jYi9UHIl4ic6WMzooNQmHK7YP%2BlXNVDFXDeQcWCpUwWd4sJ0tzK1poYmRlQdiy6IU5\/BUQu%2B\/%2B27El6KJ2dfktmRNijFFb0vgC4Bev%2BKe9YTEGf5M5xlLQHU7qXyqAX8O94d%2BsH17%2B8nLKDI5lwepYD1LhGM8vX6hNWYiah4\/iah2xB1C\/\/XC9G7mn6aAmQ6ocf2itJMoMyXVevedZK9wf2kmnviKAm8ZaWamnoPM5nKnc2DsEIlZ7Q%3D%3D"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.5}}},{"x":-57,"y":246,"basedOn":"0436c217-eff4-400f-b5f3-0f7b3ba97871","opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":10,"lockAspectRatio":false,"backgroundColor":{"color":{"r":201,"g":24,"b":74,"a":0.5}},"type":"shape","width":575,"height":368,"scale":100,"focalX":50,"focalY":50,"mask":{"type":"rectangle"},"groupId":null,"id":"797d9e93-9457-4e1b-b291-fa258c04f11b"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Darker Grotesque","fallbacks":["sans-serif"],"weights":[300,400,500,600,700,800,900],"styles":["regular"],"variants":[[0,300],[0,400],[0,500],[0,600],[0,700],[0,800],[0,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1060,"des":-296,"tAsc":1060,"tDes":-296,"tLGap":0,"wAsc":1060,"wDes":296,"xH":406,"capH":563,"yMin":-296,"yMax":1060,"hAsc":1060,"hDes":-296,"lGap":0}},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":0.9,"textAlign":"initial","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #fff\">5. Data Marts&nbsp;<\/span>\n\n<span style=\"color: #fff\">A subset of data warehouses focused on particular lines of business, departments, or subject areas. Insights can be accessed instantly without searching through entire data warehouses.<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":33,"y":289,"width":350,"height":257,"scale":100,"focalX":50,"focalY":50,"type":"text","tagName":"p","basedOn":"7cbe63a3-d2a9-44ee-9294-63419067274d","id":"32ca8626-54b5-43a4-97b6-0c0e3117794b"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":-3,"y":-40,"width":180,"height":60,"mask":{"type":"rectangle"},"type":"image","scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","creationDate":"2021-07-12T14:57:03","src":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png","width":2130,"height":708,"id":724,"alt":"InterviewBit-White-2","sizes":{"medium":{"file":"InterviewBit-White-2-300x100.png","width":300,"height":100,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png"},"large":{"file":"InterviewBit-White-2-1024x340.png","width":1024,"height":340,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png"},"thumbnail":{"file":"InterviewBit-White-2-150x150.png","width":150,"height":150,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x150.png"},"medium_large":{"file":"InterviewBit-White-2-768x255.png","width":768,"height":255,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png"},"1536x1536":{"file":"InterviewBit-White-2-1536x511.png","width":1536,"height":511,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png"},"2048x2048":{"file":"InterviewBit-White-2-2048x681.png","width":2048,"height":681,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png"},"web-stories-poster-portrait":{"file":"InterviewBit-White-2-640x708.png","width":640,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x708.png"},"web-stories-poster-landscape":{"file":"InterviewBit-White-2-853x640.png","width":853,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-853x640.png"},"web-stories-poster-square":{"file":"InterviewBit-White-2-640x640.png","width":640,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x640.png"},"web-stories-publisher-logo":{"file":"InterviewBit-White-2-96x96.png","width":96,"height":96,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-96x96.png"},"web-stories-thumbnail":{"file":"InterviewBit-White-2-150x50.png","width":150,"height":50,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png"},"full":{"file":"InterviewBit-White-2.png","width":2130,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png"}},"isOptimized":false,"isExternal":false},"basedOn":"11905f15-a6e1-4923-b588-85de48a1dac6","id":"64f0cf5b-d094-4a3f-a889-8a6a84877d81"}],"animations":[{"id":"bdfced9c-243e-4507-972a-77ffd641aa2e","type":"effect-fly-in","flyInDir":"topToBottom","duration":600,"delay":0,"targets":["32ca8626-54b5-43a4-97b6-0c0e3117794b"]},{"id":"581f3457-5181-4ed5-830c-8398510245c2","type":"effect-background-pan-and-zoom","panDir":"rightToLeft","duration":2000,"delay":0,"zoomDirection":"scaleOut","targets":["f35b4618-d680-4765-b972-9b65a643b5b0"]}],"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"type":"page","id":"59648b7b-0c10-472f-b028-64381c1481fa","pageTemplateType":"cover","groups":{"43822f2d-e2ce-445d-ac82-13372d91db61":{"name":"Background","isLocked":true,"isCollapsed":true}},"defaultBackgroundElement":{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"1dcabe56-8396-4f79-a746-181ea8ee0c35","basedOn":"8fe4f619-7591-4389-b43e-d196bd3f5eb1"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/components-of-data-warehouse\/?utm_source=Ib&utm_medium=components-of-data-warehouse&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/Components-of-Data-Warehouse-1-2048x1000.png","needsProxy":false,"ctaText":"Read More"}},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":48,"y":0,"width":330,"height":220,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"1dcabe56-8396-4f79-a746-181ea8ee0c35","basedOn":"8fe4f619-7591-4389-b43e-d196bd3f5eb1","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#f3f3f3","blurHash":"LWMZ{[?wH?%g?ufmo|x]v}Nw-pW;","type":"image","mimeType":"image\/jpeg","creationDate":"2019-11-07T22:10:23Z","src":"https:\/\/images.unsplash.com\/photo-1573164574397-dd250bc8a598?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3OHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMTk4&ixlib=rb-4.0.3&fm=jpg&w=6016&h=4016&fit=max","width":6016,"height":4016,"id":"media\/unsplash:UcZcsHSp8o4","alt":"photography of three women sits beside table inside room during daytime","sizes":{"full":{"file":"media\/unsplash:UcZcsHSp8o4","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573164574397-dd250bc8a598?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3OHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMTk4&ixlib=rb-4.0.3&fm=jpg&w=6016&h=4016&fit=max","mimeType":"image\/jpeg","width":6016,"height":4016},"large":{"file":"media\/unsplash:UcZcsHSp8o4","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573164574397-dd250bc8a598?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3OHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMTk4&ixlib=rb-4.0.3&fm=jpg&w=4812&h=3212&fit=max","mimeType":"image\/jpeg","width":4812,"height":3212},"3609_2409":{"file":"media\/unsplash:UcZcsHSp8o4","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573164574397-dd250bc8a598?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3OHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMTk4&ixlib=rb-4.0.3&fm=jpg&w=3609&h=2409&fit=max","mimeType":"image\/jpeg","width":3609,"height":2409},"2406_1606":{"file":"media\/unsplash:UcZcsHSp8o4","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573164574397-dd250bc8a598?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3OHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMTk4&ixlib=rb-4.0.3&fm=jpg&w=2406&h=1606&fit=max","mimeType":"image\/jpeg","width":2406,"height":1606},"1203_803":{"file":"media\/unsplash:UcZcsHSp8o4","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573164574397-dd250bc8a598?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3OHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMTk4&ixlib=rb-4.0.3&fm=jpg&w=1203&h=803&fit=max","mimeType":"image\/jpeg","width":1203,"height":803},"web_stories_thumbnail":{"file":"media\/unsplash:UcZcsHSp8o4","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573164574397-dd250bc8a598?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw3OHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMTk4&ixlib=rb-4.0.3&fm=jpg&w=340&h=227&fit=max","mimeType":"image\/jpeg","width":340,"height":227}},"attribution":{"author":{"displayName":"Christina @ wocintechchat.com","url":"https:\/\/unsplash.com\/@wocintechchat?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AWJwhCF\/dFAkzCx2HGZ6yGj8XmdIZXAL4mTF%2BTE\/4R4zVoDxlKPegAztv2lDqldn65RArJr8R1KIrM6LZPOtxIAi1gqxmbxkRPW4qE9iReNZhfd1ck51a6gdVv5pvTdcX7PbMyzL6166CEQq2mje4%2Bf\/Xdh0h337Yr0oW3WDkvGIZ3vHjhn4WDfv%2BvwUakKhc3j1nO4B%2Bmzf\/pus9MNCmsmbIhfbOxMKCnCYsTiZfspIb\/GaDK4qSWe%2BbDS80Jueijtqfg%3D%3D"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.5}}},{"x":-57,"y":246,"basedOn":"797d9e93-9457-4e1b-b291-fa258c04f11b","opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":10,"lockAspectRatio":false,"backgroundColor":{"color":{"r":201,"g":24,"b":74,"a":0.5}},"type":"shape","width":575,"height":368,"scale":100,"focalX":50,"focalY":50,"mask":{"type":"rectangle"},"groupId":null,"id":"cc37024e-f5c9-45f3-b1fc-3d6ddf052868"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Darker Grotesque","fallbacks":["sans-serif"],"weights":[300,400,500,600,700,800,900],"styles":["regular"],"variants":[[0,300],[0,400],[0,500],[0,600],[0,700],[0,800],[0,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1060,"des":-296,"tAsc":1060,"tDes":-296,"tLGap":0,"wAsc":1060,"wDes":296,"xH":406,"capH":563,"yMin":-296,"yMax":1060,"hAsc":1060,"hDes":-296,"lGap":0}},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":0.9,"textAlign":"initial","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #fff\">6. Data Warehouse Management and Administration&nbsp;<\/span>\n<span style=\"color: #fff\">Managing data warehouses includes: &nbsp;<\/span>\n\n<span style=\"color: #fff\">- Security &amp; priority management&nbsp;<\/span>\n<span style=\"color: #fff\">- Data quality checks&nbsp;<\/span>\n<span style=\"color: #fff\">- Managing &amp; Updating meta data&nbsp;<\/span>\n<span style=\"color: #fff\">- Purging data&nbsp;<\/span>\n","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":20,"y":288,"width":383,"height":283,"scale":100,"focalX":50,"focalY":50,"type":"text","tagName":"p","basedOn":"32ca8626-54b5-43a4-97b6-0c0e3117794b","id":"4661c22c-6637-49e7-9674-aed9476ae70b"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":-3,"y":-40,"width":180,"height":60,"mask":{"type":"rectangle"},"type":"image","scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","creationDate":"2021-07-12T14:57:03","src":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png","width":2130,"height":708,"id":724,"alt":"InterviewBit-White-2","sizes":{"medium":{"file":"InterviewBit-White-2-300x100.png","width":300,"height":100,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png"},"large":{"file":"InterviewBit-White-2-1024x340.png","width":1024,"height":340,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png"},"thumbnail":{"file":"InterviewBit-White-2-150x150.png","width":150,"height":150,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x150.png"},"medium_large":{"file":"InterviewBit-White-2-768x255.png","width":768,"height":255,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png"},"1536x1536":{"file":"InterviewBit-White-2-1536x511.png","width":1536,"height":511,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png"},"2048x2048":{"file":"InterviewBit-White-2-2048x681.png","width":2048,"height":681,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png"},"web-stories-poster-portrait":{"file":"InterviewBit-White-2-640x708.png","width":640,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x708.png"},"web-stories-poster-landscape":{"file":"InterviewBit-White-2-853x640.png","width":853,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-853x640.png"},"web-stories-poster-square":{"file":"InterviewBit-White-2-640x640.png","width":640,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x640.png"},"web-stories-publisher-logo":{"file":"InterviewBit-White-2-96x96.png","width":96,"height":96,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-96x96.png"},"web-stories-thumbnail":{"file":"InterviewBit-White-2-150x50.png","width":150,"height":50,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png"},"full":{"file":"InterviewBit-White-2.png","width":2130,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png"}},"isOptimized":false,"isExternal":false},"basedOn":"64f0cf5b-d094-4a3f-a889-8a6a84877d81","id":"5a4f926a-dc4f-49dd-a1e8-22b7a2b10cd6"}],"animations":[{"id":"96756da5-2275-4c08-9ade-8bd47855f4f3","type":"effect-fly-in","flyInDir":"topToBottom","duration":600,"delay":0,"targets":["4661c22c-6637-49e7-9674-aed9476ae70b"]},{"id":"b7c28dc2-7deb-476f-9e34-ae761edca36a","type":"effect-background-pan-and-zoom","panDir":"rightToLeft","duration":2000,"delay":0,"zoomDirection":"scaleOut","targets":["1dcabe56-8396-4f79-a746-181ea8ee0c35"]}],"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"type":"page","id":"aec8b6f0-f2ad-48e0-85b7-a304034b1979","pageTemplateType":"cover","groups":{"43822f2d-e2ce-445d-ac82-13372d91db61":{"name":"Background","isLocked":true,"isCollapsed":true}},"defaultBackgroundElement":{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"c34b045a-a64b-410e-b6a6-3972dc68dc6c","basedOn":"8fe4f619-7591-4389-b43e-d196bd3f5eb1"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/components-of-data-warehouse\/?utm_source=Ib&utm_medium=components-of-data-warehouse&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/Components-of-Data-Warehouse-1-2048x1000.png","needsProxy":false,"ctaText":"Read More"}},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":48,"y":0,"width":330,"height":247,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"1dcabe56-8396-4f79-a746-181ea8ee0c35","basedOn":"8fe4f619-7591-4389-b43e-d196bd3f5eb1","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#262626","blurHash":"LeF=:hIokWR*_4RjS3aySOs:jYaz","type":"image","mimeType":"image\/jpeg","creationDate":"2018-07-13T16:05:12Z","src":"https:\/\/images.unsplash.com\/photo-1531497865144-0464ef8fb9a9?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw4M3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&ixlib=rb-4.0.3&fm=jpg&w=5184&h=3888&fit=max","width":5184,"height":3888,"id":"media\/unsplash:-VHQ0cw2euA","alt":"people inside room","sizes":{"full":{"file":"media\/unsplash:-VHQ0cw2euA","sourceUrl":"https:\/\/images.unsplash.com\/photo-1531497865144-0464ef8fb9a9?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw4M3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&ixlib=rb-4.0.3&fm=jpg&w=5184&h=3888&fit=max","mimeType":"image\/jpeg","width":5184,"height":3888},"large":{"file":"media\/unsplash:-VHQ0cw2euA","sourceUrl":"https:\/\/images.unsplash.com\/photo-1531497865144-0464ef8fb9a9?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw4M3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&ixlib=rb-4.0.3&fm=jpg&w=4147&h=3110&fit=max","mimeType":"image\/jpeg","width":4147,"height":3110},"3110_2333":{"file":"media\/unsplash:-VHQ0cw2euA","sourceUrl":"https:\/\/images.unsplash.com\/photo-1531497865144-0464ef8fb9a9?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw4M3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&ixlib=rb-4.0.3&fm=jpg&w=3110&h=2333&fit=max","mimeType":"image\/jpeg","width":3110,"height":2333},"2073_1555":{"file":"media\/unsplash:-VHQ0cw2euA","sourceUrl":"https:\/\/images.unsplash.com\/photo-1531497865144-0464ef8fb9a9?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw4M3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&ixlib=rb-4.0.3&fm=jpg&w=2073&h=1555&fit=max","mimeType":"image\/jpeg","width":2073,"height":1555},"1036_777":{"file":"media\/unsplash:-VHQ0cw2euA","sourceUrl":"https:\/\/images.unsplash.com\/photo-1531497865144-0464ef8fb9a9?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw4M3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&ixlib=rb-4.0.3&fm=jpg&w=1036&h=777&fit=max","mimeType":"image\/jpeg","width":1036,"height":777},"web_stories_thumbnail":{"file":"media\/unsplash:-VHQ0cw2euA","sourceUrl":"https:\/\/images.unsplash.com\/photo-1531497865144-0464ef8fb9a9?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw4M3x8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY4NjkwMjA4&ixlib=rb-4.0.3&fm=jpg&w=340&h=255&fit=max","mimeType":"image\/jpeg","width":340,"height":255}},"attribution":{"author":{"displayName":"Mimi Thian","url":"https:\/\/unsplash.com\/@mimithian?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AWJwhCHae4ZoCh95dX41\/GuzhRguTZtYFpJJqExCMTYFsfJwQ%2BQ2aPySYTUL5cvY1Q6qWXprIM5jlWCF3InrdepL6V10P%2B4VR%2BbehZ5CGbTW7w11EuaF\/hVhhiTMlk5BKggO61fs1Pt%2B3CA9mN8rY07p2nCcjJyEHjeLUtTr%2BALodEuwfNFAVslpYQbNI5C4WNrQkUJ%2Byk3ZeLMKX46sjAojtXSIb4OIQxro02P86Bdp5Dx%2B%2BFVJBAXZpt3J7sThAZJEPQ%3D%3D"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.5}}},{"x":-57,"y":246,"basedOn":"cc37024e-f5c9-45f3-b1fc-3d6ddf052868","opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":10,"lockAspectRatio":false,"backgroundColor":{"color":{"r":201,"g":24,"b":74,"a":0.5}},"type":"shape","width":575,"height":368,"scale":100,"focalX":50,"focalY":50,"mask":{"type":"rectangle"},"groupId":null,"id":"c9279071-accf-4dc4-98b7-888955b3d394"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":-3,"y":-40,"width":180,"height":60,"mask":{"type":"rectangle"},"type":"image","scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","creationDate":"2021-07-12T14:57:03","src":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png","width":2130,"height":708,"id":724,"alt":"InterviewBit-White-2","sizes":{"medium":{"file":"InterviewBit-White-2-300x100.png","width":300,"height":100,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png"},"large":{"file":"InterviewBit-White-2-1024x340.png","width":1024,"height":340,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png"},"thumbnail":{"file":"InterviewBit-White-2-150x150.png","width":150,"height":150,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x150.png"},"medium_large":{"file":"InterviewBit-White-2-768x255.png","width":768,"height":255,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png"},"1536x1536":{"file":"InterviewBit-White-2-1536x511.png","width":1536,"height":511,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png"},"2048x2048":{"file":"InterviewBit-White-2-2048x681.png","width":2048,"height":681,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png"},"web-stories-poster-portrait":{"file":"InterviewBit-White-2-640x708.png","width":640,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x708.png"},"web-stories-poster-landscape":{"file":"InterviewBit-White-2-853x640.png","width":853,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-853x640.png"},"web-stories-poster-square":{"file":"InterviewBit-White-2-640x640.png","width":640,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x640.png"},"web-stories-publisher-logo":{"file":"InterviewBit-White-2-96x96.png","width":96,"height":96,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-96x96.png"},"web-stories-thumbnail":{"file":"InterviewBit-White-2-150x50.png","width":150,"height":50,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png"},"full":{"file":"InterviewBit-White-2.png","width":2130,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png"}},"isOptimized":false,"isExternal":false},"basedOn":"5a4f926a-dc4f-49dd-a1e8-22b7a2b10cd6","id":"ae40af70-da94-4b1d-ad64-befe800a9787"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Darker Grotesque","fallbacks":["sans-serif"],"weights":[300,400,500,600,700,800,900],"styles":["regular"],"variants":[[0,300],[0,400],[0,500],[0,600],[0,700],[0,800],[0,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1060,"des":-296,"tAsc":1060,"tDes":-296,"tLGap":0,"wAsc":1060,"wDes":296,"xH":406,"capH":563,"yMin":-296,"yMax":1060,"hAsc":1060,"hDes":-296,"lGap":0}},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":0.9,"textAlign":"initial","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"content":"<span style=\"font-weight: 700; color: #fff\">7. Information Delivery System<\/span>\n\n<span style=\"color: #fff\">Allocate data from the warehouse and information objects to different data warehouses and end-user products like local databases and spreadsheets.<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":26,"y":307,"width":360,"height":230,"scale":100,"focalX":50,"focalY":50,"type":"text","tagName":"p","basedOn":"4661c22c-6637-49e7-9674-aed9476ae70b","id":"1ebda62d-150a-49ce-82a2-3b049adc0b17"}],"animations":[{"id":"a35948cf-4e7d-4b91-a9d8-4adab50d0a69","type":"effect-background-pan-and-zoom","panDir":"rightToLeft","duration":2000,"delay":0,"zoomDirection":"scaleOut","targets":["1dcabe56-8396-4f79-a746-181ea8ee0c35"]},{"targets":["1ebda62d-150a-49ce-82a2-3b049adc0b17"],"id":"03fdfaf4-df17-4969-b7f6-c1e9a4b2900d","type":"effect-fly-in","flyInDir":"topToBottom","duration":600,"delay":0}],"backgroundColor":{"color":{"r":255,"g":255,"b":255}},"type":"page","id":"58a6e883-6943-4333-9ae1-d6cab2cae5f9","pageTemplateType":"cover","groups":{"43822f2d-e2ce-445d-ac82-13372d91db61":{"name":"Background","isLocked":true,"isCollapsed":true}},"defaultBackgroundElement":{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":1,"y":1,"width":1,"height":1,"mask":{"type":"rectangle"},"isBackground":true,"isDefaultBackground":true,"type":"shape","id":"65c9a86e-8e44-40f6-830f-11ad5ad3aeb4","basedOn":"8fe4f619-7591-4389-b43e-d196bd3f5eb1"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/components-of-data-warehouse\/?utm_source=Ib&utm_medium=components-of-data-warehouse&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/Components-of-Data-Warehouse-1-2048x1000.png","needsProxy":false,"ctaText":"Read More"}},{"elements":[{"x":48,"y":0,"width":330,"height":219,"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"f4e948f5-d736-4ce4-a3ee-88747553cffd","basedOn":"03d49bf5-7b5e-4d7c-b09e-7c3ebde20c94","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#262626","blurHash":"L55F8.M{8wx]x]RPVsx]IUn$x]bc","type":"image","mimeType":"image\/jpeg","creationDate":"2017-06-10T10:38:52Z","src":"https:\/\/images.unsplash.com\/photo-1497091071254-cc9b2ba7c48a?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0MHx8cmVzdW1lfGVufDB8fHx8MTY2NjA2MjgxNA&ixlib=rb-1.2.1&fm=jpg&w=4288&h=2848&fit=max","width":4288,"height":2848,"id":"media\/unsplash:P1qyEf1g0HU","alt":"person using track pad","sizes":{"full":{"file":"media\/unsplash:P1qyEf1g0HU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1497091071254-cc9b2ba7c48a?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0MHx8cmVzdW1lfGVufDB8fHx8MTY2NjA2MjgxNA&ixlib=rb-1.2.1&fm=jpg&w=4288&h=2848&fit=max","mimeType":"image\/jpeg","width":4288,"height":2848},"large":{"file":"media\/unsplash:P1qyEf1g0HU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1497091071254-cc9b2ba7c48a?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0MHx8cmVzdW1lfGVufDB8fHx8MTY2NjA2MjgxNA&ixlib=rb-1.2.1&fm=jpg&w=3430&h=2278&fit=max","mimeType":"image\/jpeg","width":3430,"height":2278},"2572_1708":{"file":"media\/unsplash:P1qyEf1g0HU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1497091071254-cc9b2ba7c48a?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0MHx8cmVzdW1lfGVufDB8fHx8MTY2NjA2MjgxNA&ixlib=rb-1.2.1&fm=jpg&w=2572&h=1708&fit=max","mimeType":"image\/jpeg","width":2572,"height":1708},"1715_1139":{"file":"media\/unsplash:P1qyEf1g0HU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1497091071254-cc9b2ba7c48a?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0MHx8cmVzdW1lfGVufDB8fHx8MTY2NjA2MjgxNA&ixlib=rb-1.2.1&fm=jpg&w=1715&h=1139&fit=max","mimeType":"image\/jpeg","width":1715,"height":1139},"857_569":{"file":"media\/unsplash:P1qyEf1g0HU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1497091071254-cc9b2ba7c48a?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0MHx8cmVzdW1lfGVufDB8fHx8MTY2NjA2MjgxNA&ixlib=rb-1.2.1&fm=jpg&w=857&h=569&fit=max","mimeType":"image\/jpeg","width":857,"height":569},"web_stories_thumbnail":{"file":"media\/unsplash:P1qyEf1g0HU","sourceUrl":"https:\/\/images.unsplash.com\/photo-1497091071254-cc9b2ba7c48a?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0MHx8cmVzdW1lfGVufDB8fHx8MTY2NjA2MjgxNA&ixlib=rb-1.2.1&fm=jpg&w=340&h=226&fit=max","mimeType":"image\/jpeg","width":340,"height":226}},"attribution":{"author":{"displayName":"Glenn Carstens-Peters","url":"https:\/\/unsplash.com\/@glenncarstenspeters?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4tqzFQk9mistNseDeeHEJMsZ1s4y0bq50WT55T0X23zUUBQBPQdK4apQBMpRXEDve3pzCQh%2B4eIoPWyosKbjNOJi0rW7VNMuRbdNCMCpD57sUk8BirmXYJAXqxgWO26HCxN6tj3TE6bIiA2wunnBSNozdaR%2B3b7GYMsOajhfH8M7uvC%2B2XPNl\/rTXwFB4gJFs%2Bkv4F2ixncVopF6zS%2BxWuraKdtkUD8aHd5uSlykrQ%3D%3D"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"type":"linear","rotation":0,"stops":[{"color":{"r":0,"g":0,"b":0,"a":0},"position":0.4},{"color":{"r":0,"g":0,"b":0,"a":1},"position":1}],"alpha":0.5}},{"x":20,"y":27,"width":81,"height":283,"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Poppins","fallbacks":["sans-serif"],"weights":[100,200,300,400,500,600,700,800,900],"styles":["italic","regular"],"variants":[[0,100],[1,100],[0,200],[1,200],[0,300],[1,300],[0,400],[1,400],[0,500],[1,500],[0,600],[1,600],[0,700],[1,700],[0,800],[1,800],[0,900],[1,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1050,"des":-350,"tAsc":1050,"tDes":-350,"tLGap":100,"wAsc":1135,"wDes":627,"xH":548,"capH":698,"yMin":-572,"yMax":1065,"hAsc":1050,"hDes":-350,"lGap":100}},"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1,"textAlign":"initial","scale":100,"focalX":50,"focalY":50,"type":"text","basedOn":"a8a8df4d-5750-4508-9698-69226f88a94f","id":"767928e9-9468-438e-bb74-51804c911c2c","content":"<span style=\"font-weight: 700; color: #fff\">\u201c<\/span>","fontSize":202,"padding":{"horizontal":0,"vertical":0}},{"x":30,"y":292,"basedOn":"3e016589-bb8b-4fa0-831c-e9995dd3ceff","opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":270,"lockAspectRatio":false,"backgroundColor":{"color":{"r":201,"g":24,"b":74}},"type":"shape","width":739,"height":27,"scale":100,"focalX":50,"focalY":50,"mask":{"type":"rectangle"},"groupId":null,"id":"c189f7a2-ccce-408a-95ed-7359e651e06d"},{"x":21,"y":170,"width":330,"height":279,"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Poppins","fallbacks":["sans-serif"],"weights":[100,200,300,400,500,600,700,800,900],"styles":["italic","regular"],"variants":[[0,100],[1,100],[0,200],[1,200],[0,300],[1,300],[0,400],[1,400],[0,500],[1,500],[0,600],[1,600],[0,700],[1,700],[0,800],[1,800],[0,900],[1,900]],"service":"fonts.google.com","metrics":{"upm":1000,"asc":1050,"des":-350,"tAsc":1050,"tDes":-350,"tLGap":100,"wAsc":1135,"wDes":627,"xH":548,"capH":698,"yMin":-572,"yMax":1065,"hAsc":1050,"hDes":-350,"lGap":100}},"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"initial","scale":100,"focalX":50,"focalY":50,"type":"text","basedOn":"37fa4bdd-2898-4b95-bf2a-ae0d4e474f47","id":"54cdc3d5-2ac7-4aa9-9aa7-364e59edb3df","content":"<span style=\"color: #fff\">Best&nbsp;<\/span>\n<span style=\"color: #fff\">Practices for Creating Data Warehouse Architecture?<\/span>","fontSize":45,"padding":{"hasHiddenPadding":false,"horizontal":0,"vertical":0},"tagName":"p","marginOffset":-33.629999999999995},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","font":{"family":"Roboto","fallbacks":["sans-serif"],"weights":[100,300,400,500,700,900],"styles":["italic","regular"],"variants":[[0,100],[1,100],[0,300],[1,300],[0,400],[1,400],[0,500],[1,500],[0,700],[1,700],[0,900],[1,900]],"service":"fonts.google.com","metrics":{"upm":2048,"asc":1900,"des":-500,"tAsc":1536,"tDes":-512,"tLGap":102,"wAsc":1946,"wDes":512,"xH":1082,"capH":1456,"yMin":-555,"yMax":2163,"hAsc":1900,"hDes":-500,"lGap":0}},"fontSize":30,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"type":"text","content":"<span style=\"color: #c9184a\">Click Here...<\/span>","borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":139,"y":528,"width":200,"height":35,"scale":100,"focalX":50,"focalY":50,"id":"83d740a7-250d-49cb-b7d9-9712d7d52b7d"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":-3,"y":-40,"width":180,"height":60,"mask":{"type":"rectangle"},"type":"image","scale":100,"focalX":50,"focalY":50,"resource":{"type":"image","mimeType":"image\/png","creationDate":"2021-07-12T14:57:03","src":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png","width":2130,"height":708,"id":724,"alt":"InterviewBit-White-2","sizes":{"medium":{"file":"InterviewBit-White-2-300x100.png","width":300,"height":100,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-300x100.png"},"large":{"file":"InterviewBit-White-2-1024x340.png","width":1024,"height":340,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1024x340.png"},"thumbnail":{"file":"InterviewBit-White-2-150x150.png","width":150,"height":150,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x150.png"},"medium_large":{"file":"InterviewBit-White-2-768x255.png","width":768,"height":255,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-768x255.png"},"1536x1536":{"file":"InterviewBit-White-2-1536x511.png","width":1536,"height":511,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-1536x511.png"},"2048x2048":{"file":"InterviewBit-White-2-2048x681.png","width":2048,"height":681,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-2048x681.png"},"web-stories-poster-portrait":{"file":"InterviewBit-White-2-640x708.png","width":640,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x708.png"},"web-stories-poster-landscape":{"file":"InterviewBit-White-2-853x640.png","width":853,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-853x640.png"},"web-stories-poster-square":{"file":"InterviewBit-White-2-640x640.png","width":640,"height":640,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-640x640.png"},"web-stories-publisher-logo":{"file":"InterviewBit-White-2-96x96.png","width":96,"height":96,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-96x96.png"},"web-stories-thumbnail":{"file":"InterviewBit-White-2-150x50.png","width":150,"height":50,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2-150x50.png"},"full":{"file":"InterviewBit-White-2.png","width":2130,"height":708,"mimeType":"image\/png","sourceUrl":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2021\/07\/InterviewBit-White-2.png"}},"isOptimized":false,"isExternal":false},"basedOn":"ea251a16-bb73-4d60-8d67-8b48c3a5f099","id":"499f4e5c-961c-4804-8c90-d8db60a5239a"}],"animations":[{"id":"3843a4f0-6821-4f6f-964c-0252e68579b0","type":"effect-fly-in","flyInDir":"topToBottom","duration":1000,"delay":0,"targets":["54cdc3d5-2ac7-4aa9-9aa7-364e59edb3df"]},{"id":"f119f207-ee41-4d81-8dc7-51807381be5f","type":"effect-fly-in","flyInDir":"topToBottom","duration":600,"delay":0,"targets":["83d740a7-250d-49cb-b7d9-9712d7d52b7d"]}],"backgroundOverlay":"none","type":"page","id":"4c8e1b8b-8c10-4ac1-a12e-2ccea42ab439","backgroundColor":{"color":{"r":0,"g":0,"b":0}},"pageTemplateType":"quote","pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/components-of-data-warehouse\/?utm_source=Ib&utm_medium=components-of-data-warehouse&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/03\/Components-of-Data-Warehouse-1-2048x1000.png","needsProxy":false,"ctaText":"SWIPE UP"},"defaultBackgroundElement":{"x":1,"y":1,"width":1,"height":1,"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"mask":{"type":"rectangle"},"isBackground":true,"type":"shape","id":"aea69b2f-a73d-495e-bc76-9f4ca40e1299","isDefaultBackground":true,"basedOn":"03d49bf5-7b5e-4d7c-b09e-7c3ebde20c94"}}],"autoAdvance":true,"defaultPageDuration":7,"currentStoryStyles":{"colors":[]}},"style_presets":{"colors":[{"color":{"r":157,"g":100,"b":32}},{"color":{"r":0,"g":0,"b":0}}],"textStyles":[]},"story_poster":{"id":14454,"url":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/11\/cropped-Components-of-Data-Warehouse.png","width":640,"height":853,"needsProxy":false},"_links":{"self":[{"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/web-story\/14433"}],"collection":[{"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/web-story"}],"about":[{"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/wp\/v2\/types\/web-story"}],"author":[{"embeddable":true,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/users\/21"}],"version-history":[{"count":4,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/web-story\/14433\/revisions"}],"predecessor-version":[{"id":14455,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/web-story\/14433\/revisions\/14455"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/media\/14454"}],"wp:attachment":[{"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/media?parent=14433"}],"wp:term":[{"taxonomy":"web_story_category","embeddable":true,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/web_story_category?post=14433"},{"taxonomy":"web_story_tag","embeddable":true,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/web_story_tag?post=14433"}],"wp:lock":[{"embeddable":true,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/web-story\/14433\/lock"}],"wp:publisherlogo":[{"embeddable":true,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/media\/1082"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}