{"id":13735,"date":"2022-10-21T22:19:56","date_gmt":"2022-10-21T16:49:56","guid":{"rendered":"https:\/\/www.interviewbit.com\/blog\/?post_type=web-story&#038;p=13735"},"modified":"2022-10-21T22:45:47","modified_gmt":"2022-10-21T17:15:47","slug":"data-warehouse-architecture","status":"publish","type":"web-story","link":"https:\/\/www.interviewbit.com\/blog\/web-stories\/data-warehouse-architecture\/","title":{"rendered":"Data Warehouse Architecture"},"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=Roboto%3Awght%40400%3B700&amp;family=Darker+Grotesque%3Awght%40400%3B700&amp;family=Anton\" rel=\"stylesheet\"\/><link href=\"https:\/\/images.unsplash.com\/photo-1558565629-637cdf4818ae?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMTd8fHNvZnR3YXJlJTIwZGV2ZWxvcGVyfGVufDB8fHx8MTY2NjM3MDg3Nw&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=4032&amp;h=3024&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 Architecture<\/title><link rel=\"canonical\" href=\"https:\/\/www.interviewbit.com\/blog\/web-stories\/data-warehouse-architecture\/\"\/><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 Architecture\" poster-portrait-src=\"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/10\/cropped-Data-Warehouse-Architecture.png\"><amp-story-page id=\"2ba48566-4303-4648-be14-d8b890969253\" 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:#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-5d6bc399-9471-4c5d-b194-d242aaf4a2b5\">\n<div style=\"position:absolute;width:237.03704%;height:100%;left:-23.01587%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1558565629-637cdf4818ae?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMTd8fHNvZnR3YXJlJTIwZGV2ZWxvcGVyfGVufDB8fHx8MTY2NjM3MDg3Nw&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=4032&amp;h=3024&amp;fit=max\" alt=\"man wearing grey shirt sitting on bench using laptop\" srcSet=\"https:\/\/images.unsplash.com\/photo-1558565629-637cdf4818ae?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMTd8fHNvZnR3YXJlJTIwZGV2ZWxvcGVyfGVufDB8fHx8MTY2NjM3MDg3Nw&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=4032&amp;h=3024&amp;fit=max 4032w,https:\/\/images.unsplash.com\/photo-1558565629-637cdf4818ae?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMTd8fHNvZnR3YXJlJTIwZGV2ZWxvcGVyfGVufDB8fHx8MTY2NjM3MDg3Nw&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=3225&amp;h=2419&amp;fit=max 3225w,https:\/\/images.unsplash.com\/photo-1558565629-637cdf4818ae?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMTd8fHNvZnR3YXJlJTIwZGV2ZWxvcGVyfGVufDB8fHx8MTY2NjM3MDg3Nw&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=2419&amp;h=1814&amp;fit=max 2419w,https:\/\/images.unsplash.com\/photo-1558565629-637cdf4818ae?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMTd8fHNvZnR3YXJlJTIwZGV2ZWxvcGVyfGVufDB8fHx8MTY2NjM3MDg3Nw&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=1612&amp;h=1209&amp;fit=max 1612w,https:\/\/images.unsplash.com\/photo-1558565629-637cdf4818ae?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMTd8fHNvZnR3YXJlJTIwZGV2ZWxvcGVyfGVufDB8fHx8MTY2NjM3MDg3Nw&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=806&amp;h=605&amp;fit=max 806w,https:\/\/images.unsplash.com\/photo-1558565629-637cdf4818ae?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMTd8fHNvZnR3YXJlJTIwZGV2ZWxvcGVyfGVufDB8fHx8MTY2NjM3MDg3Nw&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 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:0;top:-6.31068%;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-84a9fe46-f171-471f-bb69-fb55fff093d6\">\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.06796%;top:53.55987%;width:92.96117%;height:19.09385%;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.5221932114882507% 0.5221932114882507% 0.5221932114882507% 0.5221932114882507% \/ 1.694915254237288% 1.694915254237288% 1.694915254237288% 1.694915254237288%\" id=\"el-5a03f828-20ca-4b52-b11f-7a23ec19dee9\">\n<h1 id=\"data-warehouse-architecture\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.11830939947780679% 0;font-family:&quot;Roboto&quot;,sans-serif;font-size:0.809061em;line-height:1.19;text-align:left;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #fff\">Data Warehouse Architecture<\/span><\/span><\/h1>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:7.03883%;top:75.08091%;width:86.16505%;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.5633802816901409% 0.5633802816901409% 0.5633802816901409% 0.5633802816901409% \/ 5.714285714285714% 5.714285714285714% 5.714285714285714% 5.714285714285714%\" id=\"el-24c25d99-1d3e-4dc3-9ecb-bafc12cca4cf\">\n<h2 id=\"a-detailed-explanation\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.11883802816901408% 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: #ff4d6d\">A Detailed Explanation<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:27.18447%;top:90.93851%;width:41.26214%;height:15.69579%;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-210c129d-b584-43d8-8b99-78fc1afdb6da\">\n<div style=\"position:absolute;width:106.82438%;height:100%;left:-3.41219%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/media.tenor.com\/t8BoinVLwzAAAAAi\/raf-rafs.gif\" alt=\"Raf Rafs Sticker\" srcSet=\"https:\/\/media.tenor.com\/t8BoinVLwzAAAAAi\/raf-rafs.gif 498w,https:\/\/media.tenor.com\/t8BoinVLwzAAAAAj\/raf-rafs.gif 200w,https:\/\/media.tenor.com\/t8BoinVLwzAAAAAk\/raf-rafs.gif 90w\" sizes=\"(min-width: 1024px) 19vh, 41vw\" 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=\"47ddb9f2-270d-4b0d-993f-122d8b97f3fb\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-cc8b0205-3123-478d-8c9f-99d745f4adbc\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-10e8f732-98b1-4251-a71c-c392315327bc\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-2ee416ec-75b2-4af4-a2ff-a92d372fb1e3\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-2d81622e-6fc8-4b19-bc3c-736439ec998a\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-feee9eb3-f59f-4b0a-9a95-520fe69b3ec1 [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate(0%, 0%) scale(1.5)\",\"translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"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-feee9eb3-f59f-4b0a-9a95-520fe69b3ec1\" 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-783eb30d-5544-49d0-ba8f-e169faf92c1a\">\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-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MDkxNzg0&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=4016&amp;h=6016&amp;fit=max\" alt=\"person using MacBook\" srcSet=\"https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MDkxNzg0&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=4016&amp;h=6016&amp;fit=max 4016w,https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MDkxNzg0&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=3212&amp;h=4812&amp;fit=max 3212w,https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MDkxNzg0&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=2409&amp;h=3609&amp;fit=max 2409w,https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MDkxNzg0&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=1606&amp;h=2406&amp;fit=max 1606w,https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MDkxNzg0&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=803&amp;h=1203&amp;fit=max 803w,https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MDkxNzg0&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.6)\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.6)\"><\/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.33981%;top:29.77346%;width:89.56311%;height:15.04854%;opacity:1\">\n<div id=\"anim-cc8b0205-3123-478d-8c9f-99d745f4adbc\" 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-10e8f732-98b1-4251-a71c-c392315327bc\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5420054200542005% 0.5420054200542005% 0.5420054200542005% 0.5420054200542005% \/ 2.1505376344086025% 2.1505376344086025% 2.1505376344086025% 2.1505376344086025%\" id=\"el-7cd230c0-4238-4ec5-adce-927aef7b27e4\">\n<h1 id=\"introduction-to-data-warehouse\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:4.000000000000001% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.728155em;line-height:0.7;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #ff4d6d\">Introduction to Data Warehouse<\/span><\/span><\/h1>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.8932%;top:49.67638%;width:77.18447%;height:33.17152%;opacity:1\">\n<div id=\"anim-2ee416ec-75b2-4af4-a2ff-a92d372fb1e3\" 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-2d81622e-6fc8-4b19-bc3c-736439ec998a\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.628930817610063% 0.628930817610063% 0.628930817610063% 0.628930817610063% \/ 0.975609756097561% 0.975609756097561% 0.975609756097561% 0.975609756097561%\" id=\"el-7bb8f5a3-dbd4-41bc-9727-7be2fd18d627\">\n<h2 id=\"these-are-repositories-of-data-compiled-from-various-sources-including-user-manufacturer-and-third-party-reports-access-to-the-data-is-made-easier-with-tables-and-databases\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.686792452830189% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.453074em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #fff\">These are repositories of data compiled from various sources, including user, manufacturer, and third-party reports. Access to the data is made easier with tables and databases.<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:0;top:-6.31068%;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-4e3fc57d-57a7-4ed5-b0b9-486887c8c545\">\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\/06\/Client-Server-Architecture-2048x1000.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/data-warehouse-architecture\/?utm_source=Ib&amp;utm_medium=data-warehouse-architecture&amp;utm_campaign=webstories\" rel=\"\">Read More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"becbb31f-aa34-4058-b76e-6f59d68a9dae\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-c72eed2c-1cad-4304-80a8-d0d3463a6fa3\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-b354382e-5c53-48f0-96ed-fb8523e3166d\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-0976d367-06ce-4f45-b425-44d16b8aec03\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-cb01185c-7a47-48ef-a3f2-87a96fa8de27\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-c2030ffd-0624-41ce-bf1e-543f91cb261a [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate(0%, 0%) scale(1.5)\",\"translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"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:#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-c2030ffd-0624-41ce-bf1e-543f91cb261a\" 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-79aeaa82-5216-4611-a183-c2a200b7034f\">\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-1612914033131-2fbd331a3806?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1OHx8ZGF0YSUyMGFuYWx5dGljc3xlbnwwfHx8fDE2NjM3NTgzMDc&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=4000&amp;h=6000&amp;fit=max\" alt=\"Weather Reporting System using IoT\" srcSet=\"https:\/\/images.unsplash.com\/photo-1612914033131-2fbd331a3806?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1OHx8ZGF0YSUyMGFuYWx5dGljc3xlbnwwfHx8fDE2NjM3NTgzMDc&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=4000&amp;h=6000&amp;fit=max 4000w,https:\/\/images.unsplash.com\/photo-1612914033131-2fbd331a3806?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1OHx8ZGF0YSUyMGFuYWx5dGljc3xlbnwwfHx8fDE2NjM3NTgzMDc&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=3200&amp;h=4800&amp;fit=max 3200w,https:\/\/images.unsplash.com\/photo-1612914033131-2fbd331a3806?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1OHx8ZGF0YSUyMGFuYWx5dGljc3xlbnwwfHx8fDE2NjM3NTgzMDc&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=2400&amp;h=3600&amp;fit=max 2400w,https:\/\/images.unsplash.com\/photo-1612914033131-2fbd331a3806?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1OHx8ZGF0YSUyMGFuYWx5dGljc3xlbnwwfHx8fDE2NjM3NTgzMDc&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=1600&amp;h=2400&amp;fit=max 1600w,https:\/\/images.unsplash.com\/photo-1612914033131-2fbd331a3806?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1OHx8ZGF0YSUyMGFuYWx5dGljc3xlbnwwfHx8fDE2NjM3NTgzMDc&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=800&amp;h=1200&amp;fit=max 800w,https:\/\/images.unsplash.com\/photo-1612914033131-2fbd331a3806?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1OHx8ZGF0YSUyMGFuYWx5dGljc3xlbnwwfHx8fDE2NjM3NTgzMDc&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:2.42718%;top:20.87379%;width:92.47573%;height:20.06472%;opacity:1\">\n<div id=\"anim-c72eed2c-1cad-4304-80a8-d0d3463a6fa3\" 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-b354382e-5c53-48f0-96ed-fb8523e3166d\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5249343832020997% 0.5249343832020997% 0.5249343832020997% 0.5249343832020997% \/ 1.6129032258064515% 1.6129032258064515% 1.6129032258064515% 1.6129032258064515%\" id=\"el-e0b5e198-22a4-4ccc-a9ce-b141e1326301\">\n<h1 id=\"what-is-data-warehouse-architecture\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:3.874015748031497% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.728155em;line-height:0.7;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #ff4d6d\">What is Data Warehouse Architecture?<\/span><\/span><\/h1>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:44.33657%;width:76.94175%;height:38.83495%;opacity:1\">\n<div id=\"anim-0976d367-06ce-4f45-b425-44d16b8aec03\" 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-cb01185c-7a47-48ef-a3f2-87a96fa8de27\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6309148264984227% 0.6309148264984227% 0.6309148264984227% 0.6309148264984227% \/ 0.8333333333333334% 0.8333333333333334% 0.8333333333333334% 0.8333333333333334%\" id=\"el-71e82b17-746d-4d30-9fe6-72dfdfb24b08\">\n<h2 id=\"a-collection-of-interconnected-databases-that-allows-data-to-be-accessed-analyzed-and-stored-it-includes-3-main-components-data-warehouse-analytical-framework-and-integration-layer\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.688958990536278% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.453074em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #fff\">A collection of interconnected databases that allows data to be accessed, analyzed, and stored. It includes 3 main components; data warehouse, analytical framework, and integration layer.<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:0;top:-6.31068%;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-d208d954-5f5f-45d5-bef2-69c1b08a4952\">\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\/06\/Cover-Data-Warehouse-Architecture.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/data-warehouse-architecture\/?utm_source=Ib&amp;utm_medium=data-warehouse-architecture&amp;utm_campaign=webstories\" rel=\"\">Read More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"277173cc-5715-49f8-a52a-cc1d7614dffc\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-711527a6-22d9-4e00-9ab0-ab82a923d7d5\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-79a4be2a-706c-4736-b8da-5e73b8131e91\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-b6a5a252-06c5-409f-8b06-fdbfe11e97af\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-913c880e-a54d-48be-bfb2-f0e4aa5e422f\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-0a8cb4e9-e6b4-445f-b793-f1014c7a2b77 [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate(25%, 0%) scale(1.5)\",\"translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"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-0a8cb4e9-e6b4-445f-b793-f1014c7a2b77\" 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-e0704d42-fb83-49d1-8ef2-15b8d33eb223\">\n<div style=\"position:absolute;width:266.66667%;height:100%;left:0%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1515378960530-7c0da6231fb1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxsYXB0b3B8ZW58MHx8fHwxNjY1MzAwNzM4&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=5616&amp;h=3744&amp;fit=max\" alt=\"person sitting front of laptop\" srcSet=\"https:\/\/images.unsplash.com\/photo-1515378960530-7c0da6231fb1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxsYXB0b3B8ZW58MHx8fHwxNjY1MzAwNzM4&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=5616&amp;h=3744&amp;fit=max 5616w,https:\/\/images.unsplash.com\/photo-1515378960530-7c0da6231fb1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxsYXB0b3B8ZW58MHx8fHwxNjY1MzAwNzM4&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=4492&amp;h=2995&amp;fit=max 4492w,https:\/\/images.unsplash.com\/photo-1515378960530-7c0da6231fb1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxsYXB0b3B8ZW58MHx8fHwxNjY1MzAwNzM4&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=3369&amp;h=2246&amp;fit=max 3369w,https:\/\/images.unsplash.com\/photo-1515378960530-7c0da6231fb1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxsYXB0b3B8ZW58MHx8fHwxNjY1MzAwNzM4&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=2246&amp;h=1497&amp;fit=max 2246w,https:\/\/images.unsplash.com\/photo-1515378960530-7c0da6231fb1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxsYXB0b3B8ZW58MHx8fHwxNjY1MzAwNzM4&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=1123&amp;h=749&amp;fit=max 1123w,https:\/\/images.unsplash.com\/photo-1515378960530-7c0da6231fb1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxsYXB0b3B8ZW58MHx8fHwxNjY1MzAwNzM4&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=340&amp;h=227&amp;fit=max 340w\" sizes=\"(min-width: 1024px) 151vh, 336vw\" 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:2.6699%;top:18.4466%;width:94.90291%;height:22.97735%;opacity:1\">\n<div id=\"anim-711527a6-22d9-4e00-9ab0-ab82a923d7d5\" 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-79a4be2a-706c-4736-b8da-5e73b8131e91\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5115089514066496% 0.5115089514066496% 0.5115089514066496% 0.5115089514066496% \/ 1.4084507042253522% 1.4084507042253522% 1.4084507042253522% 1.4084507042253522%\" id=\"el-b8aeadef-a11d-459e-832e-54d819e58a56\">\n<h1 id=\"data-warehouse-architecture-properties\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:2.6240409207161126% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.728155em;line-height:0.9;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #ff4d6d\">Data Warehouse Architecture Properties<\/span><\/span><\/h1>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:11.65049%;top:42.88026%;width:76.94175%;height:44.01294%;opacity:1\">\n<div id=\"anim-b6a5a252-06c5-409f-8b06-fdbfe11e97af\" 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-913c880e-a54d-48be-bfb2-f0e4aa5e422f\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.6309148264984227% 0.6309148264984227% 0.6309148264984227% 0.6309148264984227% \/ 0.7352941176470588% 0.7352941176470588% 0.7352941176470588% 0.7352941176470588%\" id=\"el-10a12e2a-8a3d-47a0-bb92-294a0c6e9cff\">\n<h2 id=\"1-analytical-and-transactional-processing-should-be-kept-separate-2-maintain-data-security-3-architecture-should-be-able-to-be-extended-4-simple-and-straightforward-should-be-the-go\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.688958990536278% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.453074em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #fff\">1. Analytical and transactional processing should be kept separate.&nbsp;<\/span><br \/>\n<span style=\"color: #fff\">2. Maintain data security.<\/span><br \/>\n<span style=\"color: #fff\">3. Architecture should be able to be extended.&nbsp;<\/span><br \/>\n<span style=\"color: #fff\">4. Simple and straightforward should be the goal.<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:0;top:-6.31068%;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-338f6295-642e-4f8b-a9ce-fba05457fb50\">\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\/06\/Cover-Data-Warehouse-Architecture.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/data-warehouse-architecture\/?utm_source=Ib&amp;utm_medium=data-warehouse-architecture&amp;utm_campaign=webstories\" rel=\"\">Read More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"bc60c57e-a103-4417-900c-bd0d04f53aef\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-fe2640a7-f807-4475-b490-48ed72cd13e1\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-7627270e-62d6-4576-8bd5-b364c0a92a51\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-744d8843-3be8-4102-b861-0dfaf0ec90bd\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-19c4670b-9cb7-4923-b83d-c64f0ef6ea49\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-0c0b7e7f-1c83-4e80-8a62-dcf326f6e8f1 [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate(0%, 0%) scale(1.5)\",\"translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-db150a8e-c393-471b-869c-1016e5405b5b\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-67281ce5-0aa8-475e-8229-81a2627fb266\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"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:#0c2626\">\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-0c0b7e7f-1c83-4e80-8a62-dcf326f6e8f1\" 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-998a0474-d77b-4894-aa13-0655967a53c6\">\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-1575089976121-8ed7b2a54265?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzfHxzb2Z0d2FyZSUyMGRldmVsb3BlcnxlbnwwfHx8fDE2NjYwOTE3Mzk&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=4000&amp;h=6000&amp;fit=max\" alt=\"man using laptop\" srcSet=\"https:\/\/images.unsplash.com\/photo-1575089976121-8ed7b2a54265?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzfHxzb2Z0d2FyZSUyMGRldmVsb3BlcnxlbnwwfHx8fDE2NjYwOTE3Mzk&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=4000&amp;h=6000&amp;fit=max 4000w,https:\/\/images.unsplash.com\/photo-1575089976121-8ed7b2a54265?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzfHxzb2Z0d2FyZSUyMGRldmVsb3BlcnxlbnwwfHx8fDE2NjYwOTE3Mzk&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=3200&amp;h=4800&amp;fit=max 3200w,https:\/\/images.unsplash.com\/photo-1575089976121-8ed7b2a54265?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzfHxzb2Z0d2FyZSUyMGRldmVsb3BlcnxlbnwwfHx8fDE2NjYwOTE3Mzk&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=2400&amp;h=3600&amp;fit=max 2400w,https:\/\/images.unsplash.com\/photo-1575089976121-8ed7b2a54265?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzfHxzb2Z0d2FyZSUyMGRldmVsb3BlcnxlbnwwfHx8fDE2NjYwOTE3Mzk&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=1600&amp;h=2400&amp;fit=max 1600w,https:\/\/images.unsplash.com\/photo-1575089976121-8ed7b2a54265?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzfHxzb2Z0d2FyZSUyMGRldmVsb3BlcnxlbnwwfHx8fDE2NjYwOTE3Mzk&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=800&amp;h=1200&amp;fit=max 800w,https:\/\/images.unsplash.com\/photo-1575089976121-8ed7b2a54265?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzfHxzb2Z0d2FyZSUyMGRldmVsb3BlcnxlbnwwfHx8fDE2NjYwOTE3Mzk&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.6)\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.6)\"><\/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:2.6699%;top:16.50485%;width:94.90291%;height:22.97735%;opacity:1\">\n<div id=\"anim-fe2640a7-f807-4475-b490-48ed72cd13e1\" 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-7627270e-62d6-4576-8bd5-b364c0a92a51\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5115089514066496% 0.5115089514066496% 0.5115089514066496% 0.5115089514066496% \/ 1.4084507042253522% 1.4084507042253522% 1.4084507042253522% 1.4084507042253522%\" id=\"el-280702fd-a5f4-4b37-909d-e1d1b4c86a15\">\n<h1 id=\"types-of-data-warehouse-architectures\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:2.6240409207161126% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.728155em;line-height:0.9;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #ff4d6d\">Types of Data Warehouse Architectures<\/span><\/span><\/h1>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:9.2233%;top:52.589%;width:82.03883%;height:33.33333%;opacity:1\">\n<div id=\"anim-744d8843-3be8-4102-b861-0dfaf0ec90bd\" 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-19c4670b-9cb7-4923-b83d-c64f0ef6ea49\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.591715976331361% 0.591715976331361% 0.591715976331361% 0.591715976331361% \/ 0.9708737864077669% 0.9708737864077669% 0.9708737864077669% 0.9708737864077669%\" id=\"el-84ea2df9-ceff-472a-bac3-cf281b1ff14a\">\n<h2 id=\"single-layer-structures-are-designed-to-keep-data-space-to-a-minimum-they-can-be-used-for-batch-and-real-time-processing-but-are-not-implemented-in-real-life-systems\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.6461538461538465% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.453074em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #fff\">Single-layer structures are designed to keep data space to a minimum. They can be used for batch and real-time processing but are not implemented in real-life systems.<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:0;top:-6.31068%;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-e427c56c-96f6-4181-8a6d-d3127a2566a3\">\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:9.46602%;top:44.01294%;width:82.03883%;height:5.66343%;opacity:1\">\n<div id=\"anim-db150a8e-c393-471b-869c-1016e5405b5b\" 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-67281ce5-0aa8-475e-8229-81a2627fb266\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.591715976331361% 0.591715976331361% 0.591715976331361% 0.591715976331361% \/ 5.714285714285714% 5.714285714285714% 5.714285714285714% 5.714285714285714%\" id=\"el-56675ffb-1843-4e9e-b35f-ee2da85c3bd2\">\n<h2 id=\"single-tier-architecture\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.12481508875739646% 0;font-family:&quot;Roboto&quot;,sans-serif;font-size:0.485437em;line-height:1.2;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #fff\">Single-Tier Architecture<\/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\/06\/Cover-Data-Warehouse-Architecture.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/data-warehouse-architecture\/?utm_source=Ib&amp;utm_medium=data-warehouse-architecture&amp;utm_campaign=webstories\" rel=\"\">Read More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"f8edc689-b3b9-402a-bbe2-412ff0f6f60f\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-3fe9a77b-4387-4193-a56b-0d0cdf404718 [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate(25%, 0%) scale(1.5)\",\"translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-ab267aff-18dd-4b76-880d-9ec177e06fb3\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-897dc939-647a-4ca4-aac3-299e3e625930\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-c58a5467-d88f-482f-b2af-35b507dcb110\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-34801d16-5c07-4c59-87f9-d5795a946cec\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"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-3fe9a77b-4387-4193-a56b-0d0cdf404718\" 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-13922a8c-9d16-438b-bf06-93ebb7d22548\">\n<div style=\"position:absolute;width:118.57814%;height:100%;left:0%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&amp;ixlib=rb-1.2.1&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=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=5304&amp;h=7952&amp;fit=max 5304w,https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=4243&amp;h=6361&amp;fit=max 4243w,https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=3182&amp;h=4771&amp;fit=max 3182w,https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=2121&amp;h=3180&amp;fit=max 2121w,https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=1060&amp;h=1589&amp;fit=max 1060w,https:\/\/images.unsplash.com\/photo-1580894899378-92e56886cd4d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&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.6)\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"page-background-overlay-area\" style=\"background-color:rgba(0,0,0,0.6)\"><\/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:8.73786%;top:46.92557%;width:83.00971%;height:33.17152%;opacity:1\">\n<div id=\"anim-ab267aff-18dd-4b76-880d-9ec177e06fb3\" 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-897dc939-647a-4ca4-aac3-299e3e625930\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5847953216374269% 0.5847953216374269% 0.5847953216374269% 0.5847953216374269% \/ 0.975609756097561% 0.975609756097561% 0.975609756097561% 0.975609756097561%\" id=\"el-c3b82f1b-f33e-4c30-8ccf-11baeb3dc8a6\">\n<h2 id=\"in-this-analytical-process-is-separated-from-business-process-allowing-for-increased-control-and-efficiency-the-data-can-also-be-better-understood-enabling-more-informed-decisions\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.6385964912280705% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.453074em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #fff\">In this, analytical process is separated from business process, allowing for increased control and efficiency. The data can also be better understood, enabling more informed decisions.<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:0;top:-6.31068%;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-ae498364-c80d-4848-9477-e6dcc4017a00\">\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:9.70874%;top:36.24595%;width:82.03883%;height:5.66343%;opacity:1\">\n<div id=\"anim-c58a5467-d88f-482f-b2af-35b507dcb110\" 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-34801d16-5c07-4c59-87f9-d5795a946cec\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.591715976331361% 0.591715976331361% 0.591715976331361% 0.591715976331361% \/ 5.714285714285714% 5.714285714285714% 5.714285714285714% 5.714285714285714%\" id=\"el-54a0b92e-9f75-4f61-9272-be78f064d769\">\n<h2 id=\"two-tier-architecture\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.12481508875739646% 0;font-family:&quot;Roboto&quot;,sans-serif;font-size:0.485437em;line-height:1.2;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #fff\">Two-Tier Architecture<\/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\/06\/Cover-Data-Warehouse-Architecture.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/data-warehouse-architecture\/?utm_source=Ib&amp;utm_medium=data-warehouse-architecture&amp;utm_campaign=webstories\" rel=\"\">Read More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"c3b1d1c6-99fb-45e1-b62f-98e3c63d7827\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-a5e7c561-b371-4e0d-9aee-c7261035e786\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-2c84aef0-08e1-437e-800a-855f0b3cb361\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-b20b4a7d-4bd1-4f2e-85c8-9e1b35c5c3be [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate(0%, 0%) scale(1.5)\",\"translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-207b6e7f-6a84-4a25-9f6c-1b1a87fa4f7b\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-0f2434ee-7f79-40c7-86d4-521fc1aa90db\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"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:#0c2626\">\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-b20b4a7d-4bd1-4f2e-85c8-9e1b35c5c3be\" 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-2a49e5fe-7400-41ee-bdd0-0620e4c26af0\">\n<div style=\"position:absolute;width:275.05241%;height:100%;left:-87.52621%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1605379399843-5870eea9b74e?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=3936&amp;h=2544&amp;fit=max\" alt=\"black flat screen computer monitor\" srcSet=\"https:\/\/images.unsplash.com\/photo-1605379399843-5870eea9b74e?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=3936&amp;h=2544&amp;fit=max 3936w,https:\/\/images.unsplash.com\/photo-1605379399843-5870eea9b74e?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=3148&amp;h=2035&amp;fit=max 3148w,https:\/\/images.unsplash.com\/photo-1605379399843-5870eea9b74e?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=2361&amp;h=1526&amp;fit=max 2361w,https:\/\/images.unsplash.com\/photo-1605379399843-5870eea9b74e?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=1574&amp;h=1017&amp;fit=max 1574w,https:\/\/images.unsplash.com\/photo-1605379399843-5870eea9b74e?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=787&amp;h=509&amp;fit=max 787w,https:\/\/images.unsplash.com\/photo-1605379399843-5870eea9b74e?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=340&amp;h=220&amp;fit=max 340w\" sizes=\"(min-width: 1024px) 124vh, 275vw\" 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:8.73786%;top:46.92557%;width:83.00971%;height:33.17152%;opacity:1\">\n<div id=\"anim-a5e7c561-b371-4e0d-9aee-c7261035e786\" 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-2c84aef0-08e1-437e-800a-855f0b3cb361\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5847953216374269% 0.5847953216374269% 0.5847953216374269% 0.5847953216374269% \/ 0.975609756097561% 0.975609756097561% 0.975609756097561% 0.975609756097561%\" id=\"el-ced126bf-3c38-43c6-a006-058a925018af\">\n<h2 id=\"it-is-employed-in-source-layer-reconciled-layer-and-data-warehouse-layer-reconciler-sits-between-source-data-and-data-warehouse-and-focus-primarily-on-data-integrity-and-accuracy\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.6385964912280705% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.453074em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #fff\">It is employed in source layer, &nbsp;reconciled layer, and data warehouse layer. Reconciler sits between source data and data warehouse, and focus primarily on data integrity, and accuracy.<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:0;top:-6.31068%;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-ac80a5e9-0bd3-45c9-a60e-bb31e15d12bd\">\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:9.70874%;top:36.24595%;width:82.03883%;height:5.66343%;opacity:1\">\n<div id=\"anim-207b6e7f-6a84-4a25-9f6c-1b1a87fa4f7b\" 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-0f2434ee-7f79-40c7-86d4-521fc1aa90db\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.591715976331361% 0.591715976331361% 0.591715976331361% 0.591715976331361% \/ 5.714285714285714% 5.714285714285714% 5.714285714285714% 5.714285714285714%\" id=\"el-f5bb58eb-5acc-433d-81ca-fcd1271bf1c7\">\n<h2 id=\"three-tier-architecture\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:-0.12481508875739646% 0;font-family:&quot;Roboto&quot;,sans-serif;font-size:0.485437em;line-height:1.2;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #fff\">Three-Tier Architecture<\/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\/06\/Cover-Data-Warehouse-Architecture.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/data-warehouse-architecture\/?utm_source=Ib&amp;utm_medium=data-warehouse-architecture&amp;utm_campaign=webstories\" rel=\"\">Read More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"6a8b5715-a613-4b9b-b812-4e9eb036a638\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-f2b95988-2320-427e-80f5-fb7b4baa692d\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-7ac29810-1b9b-4faa-8df1-2c26bbcb49b1\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-099a080e-a393-4ebc-a105-660aa638915a\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-01c9ab37-c0a1-4556-aba7-5e31c6cdde6f\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-874771dd-d8aa-46cc-ac07-c918b0fad9a4 [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate(0%, 0%) scale(1.5)\",\"translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"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:#260c0c\">\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-874771dd-d8aa-46cc-ac07-c918b0fad9a4\" 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-2a49e5fe-7400-41ee-bdd0-0620e4c26af0\">\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-1603575448878-868a20723f5d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=6000&amp;h=4000&amp;fit=max\" alt=\"man in black crew neck t-shirt using macbook\" srcSet=\"https:\/\/images.unsplash.com\/photo-1603575448878-868a20723f5d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=6000&amp;h=4000&amp;fit=max 6000w,https:\/\/images.unsplash.com\/photo-1603575448878-868a20723f5d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=4800&amp;h=3200&amp;fit=max 4800w,https:\/\/images.unsplash.com\/photo-1603575448878-868a20723f5d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=3600&amp;h=2400&amp;fit=max 3600w,https:\/\/images.unsplash.com\/photo-1603575448878-868a20723f5d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=2400&amp;h=1600&amp;fit=max 2400w,https:\/\/images.unsplash.com\/photo-1603575448878-868a20723f5d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=1200&amp;h=800&amp;fit=max 1200w,https:\/\/images.unsplash.com\/photo-1603575448878-868a20723f5d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&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:8.49515%;top:54.04531%;width:83.00971%;height:27.99353%;opacity:1\">\n<div id=\"anim-f2b95988-2320-427e-80f5-fb7b4baa692d\" 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-7ac29810-1b9b-4faa-8df1-2c26bbcb49b1\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5847953216374269% 0.5847953216374269% 0.5847953216374269% 0.5847953216374269% \/ 1.1560693641618496% 1.1560693641618496% 1.1560693641618496% 1.1560693641618496%\" id=\"el-4a3b6f89-51ac-4cf0-9a15-56afd82246b6\">\n<h2 id=\"1-speeds-up-data-retrieving-2-helps-in-error-identification-and-correction-3-support-etl-processes-4-enables-real-time-analytics\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.6385964912280705% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.453074em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #fff\">1. Speeds up Data Retrieving.&nbsp;<\/span><br \/>\n<span style=\"color: #fff\">2. Helps in error identification and correction.<\/span><br \/>\n<span style=\"color: #fff\">3. Support ETL processes.&nbsp;<\/span><br \/>\n<span style=\"color: #fff\">4. Enables real-time analytics.<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:0;top:-6.31068%;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-8a6e2793-4e01-4152-9b66-952d8b2d8dd3\">\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:2.6699%;top:27.02265%;width:94.90291%;height:22.97735%;opacity:1\">\n<div id=\"anim-099a080e-a393-4ebc-a105-660aa638915a\" 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-01c9ab37-c0a1-4556-aba7-5e31c6cdde6f\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5115089514066496% 0.5115089514066496% 0.5115089514066496% 0.5115089514066496% \/ 1.4084507042253522% 1.4084507042253522% 1.4084507042253522% 1.4084507042253522%\" id=\"el-fd765e85-fb99-4870-bbec-bdbaa7341ecc\">\n<h1 id=\"advantages-of-data-warehouse-architecture\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:2.6240409207161126% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.728155em;line-height:0.9;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #ff4d6d\">Advantages of Data Warehouse Architecture<\/span><\/span><\/h1>\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\/06\/Client-Server-Architecture-2048x1000.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/data-warehouse-architecture\/?utm_source=Ib&amp;utm_medium=data-warehouse-architecture&amp;utm_campaign=webstories\" rel=\"\">Read More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"3c95b9a9-c73a-49b1-af00-dfb2b4d04abc\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-e526ec12-e369-473a-9556-3501f500d403\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-7989c897-74aa-4d8f-be1b-ae1f31382cd7\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-a38e8b4a-75cd-400d-add3-4d2aad3a2310\",\"keyframes\":{\"opacity\":[0,1]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"both\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-82f4cf62-06ba-462a-a09f-080244247f59\",\"keyframes\":{\"transform\":[\"scale(0.3333333333333333)\",\"scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"fill\":\"forwards\"}]<\/script><\/amp-story-animation><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-40fa3194-8962-440a-b017-5bbbed14c13f [data-leaf-element=\\\"true\\\"]\",\"keyframes\":{\"transform\":[\"translate(0%, 0%) scale(1.5)\",\"translate(0%, 0%) scale(1)\"]},\"delay\":0,\"duration\":2000,\"easing\":\"cubic-bezier(.3,0,.55,1)\",\"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-40fa3194-8962-440a-b017-5bbbed14c13f\" 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-2a49e5fe-7400-41ee-bdd0-0620e4c26af0\">\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-1573165850883-9b0e18c44bd2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1NXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjU3&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=4016&amp;h=6016&amp;fit=max\" alt=\"woman in black blazer using MacBook\" srcSet=\"https:\/\/images.unsplash.com\/photo-1573165850883-9b0e18c44bd2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1NXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjU3&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=4016&amp;h=6016&amp;fit=max 4016w,https:\/\/images.unsplash.com\/photo-1573165850883-9b0e18c44bd2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1NXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjU3&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=3212&amp;h=4812&amp;fit=max 3212w,https:\/\/images.unsplash.com\/photo-1573165850883-9b0e18c44bd2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1NXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjU3&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=2409&amp;h=3609&amp;fit=max 2409w,https:\/\/images.unsplash.com\/photo-1573165850883-9b0e18c44bd2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1NXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjU3&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=1606&amp;h=2406&amp;fit=max 1606w,https:\/\/images.unsplash.com\/photo-1573165850883-9b0e18c44bd2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1NXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjU3&amp;ixlib=rb-4.0.3&amp;fm=jpg&amp;w=803&amp;h=1203&amp;fit=max 803w,https:\/\/images.unsplash.com\/photo-1573165850883-9b0e18c44bd2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1NXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjU3&amp;ixlib=rb-4.0.3&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:8.49515%;top:47.08738%;width:83.00971%;height:38.83495%;opacity:1\">\n<div id=\"anim-e526ec12-e369-473a-9556-3501f500d403\" 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-7989c897-74aa-4d8f-be1b-ae1f31382cd7\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5847953216374269% 0.5847953216374269% 0.5847953216374269% 0.5847953216374269% \/ 0.8333333333333334% 0.8333333333333334% 0.8333333333333334% 0.8333333333333334%\" id=\"el-643f7bb3-7b41-450b-8e7c-10d46bd4c300\">\n<h2 id=\"1-require-a-lot-of-maintenance-2-hight-maintenance-costs-3-automated-extraction-cannot-guarantee-data-cleaning-and-validation-4-hidden-problems-of-data-sources\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:0.6385964912280705% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.453074em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #fff\">1. Require a lot of maintenance.<\/span><br \/>\n<span style=\"color: #fff\">2.Hight maintenance costs.&nbsp;<\/span><br \/>\n<span style=\"color: #fff\">3. Automated extraction cannot guarantee data cleaning and validation.&nbsp;<\/span><br \/>\n<span style=\"color: #fff\">4. Hidden problems of data sources<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:0;top:-6.31068%;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-229e3eb4-2063-495d-b2e1-568c1c08318d\">\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:2.42718%;top:20.38835%;width:94.90291%;height:22.97735%;opacity:1\">\n<div id=\"anim-a38e8b4a-75cd-400d-add3-4d2aad3a2310\" 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-82f4cf62-06ba-462a-a09f-080244247f59\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:scale(0.3333333333333333)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0;border-radius:0.5115089514066496% 0.5115089514066496% 0.5115089514066496% 0.5115089514066496% \/ 1.4084507042253522% 1.4084507042253522% 1.4084507042253522% 1.4084507042253522%\" id=\"el-4fee5d6f-1aa7-4932-873d-73eed814e976\">\n<h1 id=\"disadvantages-of-data-warehouse-architecture\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:2.6240409207161126% 0;font-family:&quot;Darker Grotesque&quot;,sans-serif;font-size:0.728155em;line-height:0.9;text-align:center;padding:0;color:#000000\"><span><span style=\"font-weight: 700; color: #ff4d6d\">Disadvantages of Data Warehouse Architecture<\/span><\/span><\/h1>\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\/06\/Cover-Data-Warehouse-Architecture.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/data-warehouse-architecture\/?utm_source=Ib&amp;utm_medium=data-warehouse-architecture&amp;utm_campaign=webstories\" rel=\"\">Read More<\/a><\/amp-story-page-outlink><\/amp-story-page><amp-story-page id=\"b2cd7624-c3ec-4a7d-9867-d7d4dc8f0933\" auto-advance-after=\"7s\"><amp-story-animation layout=\"nodisplay\" trigger=\"visibility\"><script type=\"application\/json\">[{\"selector\":\"#anim-ae43c266-8a35-493f-957c-525ee7152bb4\",\"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-ea243abf-fd74-4e3d-b1a8-cfb357ef7dbf\",\"keyframes\":{\"transform\":[\"translate3d(0px, 141.39260%, 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-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 style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" class=\"mask\" id=\"el-d27e8c8f-9d92-46c4-b5fa-0dae2eeea7a3\">\n<div style=\"position:absolute;width:118.28336%;height:100%;left:-9.14168%;top:0%\" data-leaf-element=\"true\"><amp-img layout=\"fill\" src=\"https:\/\/images.unsplash.com\/photo-1655794387399-6dd29236eaa1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxhcmNoaXRlY3R1cmFsJTIwcGF0dGVybnxlbnwwfHx8fDE2NjYwODk2MzU&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=4024&amp;h=6048&amp;fit=max\" alt=\"Architecture- contemporary\" srcSet=\"https:\/\/images.unsplash.com\/photo-1655794387399-6dd29236eaa1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxhcmNoaXRlY3R1cmFsJTIwcGF0dGVybnxlbnwwfHx8fDE2NjYwODk2MzU&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=4024&amp;h=6048&amp;fit=max 4024w,https:\/\/images.unsplash.com\/photo-1655794387399-6dd29236eaa1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxhcmNoaXRlY3R1cmFsJTIwcGF0dGVybnxlbnwwfHx8fDE2NjYwODk2MzU&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=3219&amp;h=4838&amp;fit=max 3219w,https:\/\/images.unsplash.com\/photo-1655794387399-6dd29236eaa1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxhcmNoaXRlY3R1cmFsJTIwcGF0dGVybnxlbnwwfHx8fDE2NjYwODk2MzU&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=2414&amp;h=3628&amp;fit=max 2414w,https:\/\/images.unsplash.com\/photo-1655794387399-6dd29236eaa1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxhcmNoaXRlY3R1cmFsJTIwcGF0dGVybnxlbnwwfHx8fDE2NjYwODk2MzU&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=1609&amp;h=2418&amp;fit=max 1609w,https:\/\/images.unsplash.com\/photo-1655794387399-6dd29236eaa1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxhcmNoaXRlY3R1cmFsJTIwcGF0dGVybnxlbnwwfHx8fDE2NjYwODk2MzU&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=804&amp;h=1208&amp;fit=max 804w,https:\/\/images.unsplash.com\/photo-1655794387399-6dd29236eaa1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxhcmNoaXRlY3R1cmFsJTIwcGF0dGVybnxlbnwwfHx8fDE2NjYwODk2MzU&amp;ixlib=rb-1.2.1&amp;fm=jpg&amp;w=340&amp;h=511&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:11.8932%;top:23.46278%;width:65.7767%;height:60.67961%;opacity:1\">\n<div id=\"anim-ae43c266-8a35-493f-957c-525ee7152bb4\" 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-ea243abf-fd74-4e3d-b1a8-cfb357ef7dbf\" class=\"animation-wrapper\" style=\"width:100%;height:100%;display:block;position:absolute;top:0;left:0;--initial-opacity:1;--initial-transform:translate3d(0px, 141.39260%, 0)\">\n<div style=\"pointer-events:initial;width:100%;height:100%;display:block;position:absolute;top:0;left:0;z-index:0\" id=\"el-021e0541-35be-4946-80af-40b0a2d780a0\">\n<h2 id=\"for-more-information-on-data-warehouse-architecture-click-here\" class=\"fill text-wrapper\" style=\"white-space:pre-line;overflow-wrap:break-word;word-break:break-word;margin:2.817076510608856% 0;font-family:&quot;Anton&quot;,sans-serif;font-size:0.809061em;line-height:1.2;text-align:left;padding:0;color:#000000\"><span><span style=\"color: #faf4ea\">For more information on data warehouse architecture, click here&#8230;<\/span><\/span><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"position:absolute;pointer-events:none;left:0;top:-6.31068%;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-d6783a38-6f55-44eb-b06c-5d94b750e921\">\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\/06\/Cover-Data-Warehouse-Architecture.png\"><a href=\"https:\/\/www.interviewbit.com\/blog\/data-warehouse-architecture\/?utm_source=Ib&amp;utm_medium=data-warehouse-architecture&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":"The purpose of this web story is to explain in detail what data warehouse architecture is, and what makes it so powerful.\n","protected":false},"author":21,"featured_media":13739,"template":"","meta":{"_daextam_enable_autolinks":"","web_stories_products":[],"web_stories_publisher_logo":1082,"web_stories_poster":[]},"web_story_category":[1791],"web_story_tag":[1833,1832],"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":247,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"5d6bc399-9471-4c5d-b194-d242aaf4a2b5","basedOn":"11ef0ff2-7ece-45b6-b2ff-64736e54ce84","scale":100,"focalX":30.80357142857143,"focalY":50,"resource":{"baseColor":"#262626","blurHash":"LjDcq3M|t6t7.Aj[WBfktSozoJjZ","type":"image","mimeType":"image\/jpeg","creationDate":"2019-05-22T22:53:53Z","src":"https:\/\/images.unsplash.com\/photo-1558565629-637cdf4818ae?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMTd8fHNvZnR3YXJlJTIwZGV2ZWxvcGVyfGVufDB8fHx8MTY2NjM3MDg3Nw&ixlib=rb-4.0.3&fm=jpg&w=4032&h=3024&fit=max","width":4032,"height":3024,"id":"media\/unsplash:0ft4oRgqzjo","alt":"man wearing grey shirt sitting on bench using laptop","sizes":{"full":{"file":"media\/unsplash:0ft4oRgqzjo","sourceUrl":"https:\/\/images.unsplash.com\/photo-1558565629-637cdf4818ae?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMTd8fHNvZnR3YXJlJTIwZGV2ZWxvcGVyfGVufDB8fHx8MTY2NjM3MDg3Nw&ixlib=rb-4.0.3&fm=jpg&w=4032&h=3024&fit=max","mimeType":"image\/jpeg","width":4032,"height":3024},"large":{"file":"media\/unsplash:0ft4oRgqzjo","sourceUrl":"https:\/\/images.unsplash.com\/photo-1558565629-637cdf4818ae?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMTd8fHNvZnR3YXJlJTIwZGV2ZWxvcGVyfGVufDB8fHx8MTY2NjM3MDg3Nw&ixlib=rb-4.0.3&fm=jpg&w=3225&h=2419&fit=max","mimeType":"image\/jpeg","width":3225,"height":2419},"2419_1814":{"file":"media\/unsplash:0ft4oRgqzjo","sourceUrl":"https:\/\/images.unsplash.com\/photo-1558565629-637cdf4818ae?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMTd8fHNvZnR3YXJlJTIwZGV2ZWxvcGVyfGVufDB8fHx8MTY2NjM3MDg3Nw&ixlib=rb-4.0.3&fm=jpg&w=2419&h=1814&fit=max","mimeType":"image\/jpeg","width":2419,"height":1814},"1612_1209":{"file":"media\/unsplash:0ft4oRgqzjo","sourceUrl":"https:\/\/images.unsplash.com\/photo-1558565629-637cdf4818ae?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMTd8fHNvZnR3YXJlJTIwZGV2ZWxvcGVyfGVufDB8fHx8MTY2NjM3MDg3Nw&ixlib=rb-4.0.3&fm=jpg&w=1612&h=1209&fit=max","mimeType":"image\/jpeg","width":1612,"height":1209},"806_605":{"file":"media\/unsplash:0ft4oRgqzjo","sourceUrl":"https:\/\/images.unsplash.com\/photo-1558565629-637cdf4818ae?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMTd8fHNvZnR3YXJlJTIwZGV2ZWxvcGVyfGVufDB8fHx8MTY2NjM3MDg3Nw&ixlib=rb-4.0.3&fm=jpg&w=806&h=605&fit=max","mimeType":"image\/jpeg","width":806,"height":605},"web_stories_thumbnail":{"file":"media\/unsplash:0ft4oRgqzjo","sourceUrl":"https:\/\/images.unsplash.com\/photo-1558565629-637cdf4818ae?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMTd8fHNvZnR3YXJlJTIwZGV2ZWxvcGVyfGVufDB8fHx8MTY2NjM3MDg3Nw&ixlib=rb-4.0.3&fm=jpg&w=340&h=255&fit=max","mimeType":"image\/jpeg","width":340,"height":255}},"attribution":{"author":{"displayName":"Austin P","url":"https:\/\/unsplash.com\/@pqt?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4toa0Q\/91QU1QYe96Tk\/pM93UcUD1WzHn8pxZy%2Bzja1poFh%2Blx\/bP2c68%2BCLJWpHajEtwPZMnRVgTlgPd3CICWmpVmufpdkMbS2%2BgR%2B2W8WdMXnthPMpV03NmJpaamMmy8M5HcAr8aHypePWTfDB4zCajAO1x6afQMYPEr4heU2aljjI4S6CEY2f4a2%2BnBqTSfCKZ60TNqufOCsCz4QVx8fbDXIthHtIAJE8sWOpHRYdfYrnfLnJhRmXl6RRtOt0Ql6K"},"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":true,"x":0,"y":-39,"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":"bcc685a3-50e0-4220-aa2d-37d04255b533","id":"84a9fe46-f171-471f-bb69-fb55fff093d6"},{"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":50,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.19,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"type":"text","content":"<span style=\"font-weight: 700; color: #fff\">Data Warehouse Architecture<\/span>","borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":25,"y":331,"width":383,"height":118,"scale":100,"focalX":50,"focalY":50,"id":"5a03f828-20ca-4b52-b11f-7a23ec19dee9"},{"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: #ff4d6d\">A Detailed Explanation<\/span>","borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":29,"y":464,"width":355,"height":35,"scale":100,"focalX":50,"focalY":50,"id":"24c25d99-1d3e-4dc3-9ecb-bafc12cca4cf"},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":false,"scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#dbdbdb","type":"image","mimeType":"image\/gif","creationDate":"2020-04-27T17:14:34Z","src":"https:\/\/media.tenor.com\/t8BoinVLwzAAAAAi\/raf-rafs.gif","width":498,"height":266,"id":"media\/tenor:13240697848351933232","alt":"Raf Rafs Sticker","sizes":{"full":{"file":"media\/tenor:13240697848351933232","sourceUrl":"https:\/\/media.tenor.com\/t8BoinVLwzAAAAAi\/raf-rafs.gif","mimeType":"image\/gif","width":498,"height":266},"large":{"file":"media\/tenor:13240697848351933232","sourceUrl":"https:\/\/c.tenor.com\/t8BoinVLwzAAAAAq\/tenor.gif","mimeType":"image\/gif","width":498,"height":266},"200_107":{"file":"media\/tenor:13240697848351933232","sourceUrl":"https:\/\/media.tenor.com\/t8BoinVLwzAAAAAj\/raf-rafs.gif","mimeType":"image\/gif","width":200,"height":107},"web_stories_thumbnail":{"file":"media\/tenor:13240697848351933232","sourceUrl":"https:\/\/media.tenor.com\/t8BoinVLwzAAAAAk\/raf-rafs.gif","mimeType":"image\/gif","width":90,"height":48}},"attribution":{"author":{"displayName":"RafsDesign","url":"https:\/\/tenor.com\/official\/RafsDesign"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4tpR6rfJ7qEuXy3Oo\/YygtZ9kIF00bzr2GWwrvGS4AFAjeNOq5K4dTEzNhIHTy20RwVlCRy13e9I8%2BZClXBL\/HS86ec%3D"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"type":"image","x":112,"y":562,"width":170,"height":97,"mask":{"type":"rectangle","showInLibrary":true,"name":"Rectangle","path":"M 0,0 1,0 1,1 0,1 0,0 Z","ratio":1,"supportsBorder":true},"id":"210c129d-b584-43d8-8b99-78fc1afdb6da"}],"animations":[],"backgroundOverlay":"none","backgroundColor":{"color":{"r":18,"g":32,"b":54}},"type":"page","id":"2ba48566-4303-4648-be14-d8b890969253","pageTemplateType":"section","groups":[],"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":"af98cec1-7c0d-4438-810a-ebec9e723603","basedOn":"11ef0ff2-7ece-45b6-b2ff-64736e54ce84"},"pageAttachment":{"url":"","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/05\/MVC-Architecture-2048x1152.png","needsProxy":false,"ctaText":"SWIPE UP"}},{"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":"783eb30d-5544-49d0-ba8f-e169faf92c1a","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#f3f3f3","blurHash":"LKIhgNI;-;~W4.eSRPS5~CtlD*ad","type":"image","mimeType":"image\/jpeg","creationDate":"2019-11-11T18:11:49Z","src":"https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MDkxNzg0&ixlib=rb-1.2.1&fm=jpg&w=4016&h=6016&fit=max","width":4016,"height":6016,"id":"media\/unsplash:5UHFPbvBBzY","alt":"person using MacBook","sizes":{"full":{"file":"media\/unsplash:5UHFPbvBBzY","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MDkxNzg0&ixlib=rb-1.2.1&fm=jpg&w=4016&h=6016&fit=max","mimeType":"image\/jpeg","width":4016,"height":6016},"large":{"file":"media\/unsplash:5UHFPbvBBzY","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MDkxNzg0&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:5UHFPbvBBzY","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MDkxNzg0&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:5UHFPbvBBzY","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MDkxNzg0&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:5UHFPbvBBzY","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MDkxNzg0&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:5UHFPbvBBzY","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573495628363-04667cedc587?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MDkxNzg0&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=AQBR4tqUr1xOhgAYvkL4MJUmONbyxohR\/8BVFpsSAKyoWBTT\/eM2bPnAlhjcTaoo9KoInHkStzpO%2Bh5eaK7fyrb0iFG8fQMzoj5MlDIvqurEpBjPl2ZlDaSOCwoQ1sJ4UMzOKjSF5SK5SVuUshwGajgPssVSIzsQAVO\/6kmBJkgeZNHGQqE9l\/mlsB4JByUADTh\/8qJ4wapKkUq4pWX2BUnmT4P1QBhKWWE2TJ52rYYHAp9hphC\/D%2BAWjvI7xkBPqhFX0Q%3D%3D"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.6}}},{"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":45,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":0.7,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false},"type":"text","content":"<span style=\"font-weight: 700; color: #ff4d6d\">Introduction to Data Warehouse<\/span>","fontWeight":700,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":22,"y":184,"width":369,"height":93,"scale":100,"focalX":50,"focalY":50,"id":"7cd230c0-4238-4ec5-adce-927aef7b27e4","marginOffset":-33.45600000000001,"basedOn":"14bb0c1d-b114-4235-8cfa-a9650723dd19","groupId":null},{"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":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":null,"vertical":null},"type":"text","content":"<span style=\"color: #fff\">These are repositories of data compiled from various sources, including user, manufacturer, and third-party reports. Access to the data is made easier with tables and databases.<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"width":318,"height":205,"scale":100,"focalX":50,"focalY":50,"basedOn":"9b73ef3b-3831-463a-995d-86e6b3244924","id":"7bb8f5a3-dbd4-41bc-9727-7be2fd18d627","x":49,"y":307,"groupId":null},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":0,"y":-39,"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":"c9cca87f-ec14-4c35-8f9e-b4f3dc7be41f","id":"4e3fc57d-57a7-4ed5-b0b9-486887c8c545"}],"animations":[{"id":"0b028b83-7635-4a07-9ab3-2c88bd973be3","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["7cd230c0-4238-4ec5-adce-927aef7b27e4"]},{"id":"b54acda9-6d33-4bf3-adf3-81d52bd5d0a9","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["7bb8f5a3-dbd4-41bc-9727-7be2fd18d627"]},{"id":"cdd82363-b161-4dda-b77f-ce027f55d353","type":"effect-background-zoom","zoomDirection":"scaleOut","duration":2000,"delay":0,"targets":["783eb30d-5544-49d0-ba8f-e169faf92c1a"]}],"backgroundOverlay":"none","backgroundColor":{"color":{"r":18,"g":32,"b":54}},"type":"page","id":"47ddb9f2-270d-4b0d-993f-122d8b97f3fb","pageTemplateType":"section","groups":[],"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":"339d54b3-4375-43d9-946f-5e2e13737454","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/data-warehouse-architecture\/?utm_source=Ib&utm_medium=data-warehouse-architecture&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/06\/Client-Server-Architecture-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":"79aeaa82-5216-4611-a183-c2a200b7034f","basedOn":"3fb7a607-01df-4a01-82d2-00cf755a3e1c","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#262626","blurHash":"LeF~mtD%IUt8~qayM{t7kBt8j?Rj","type":"image","mimeType":"image\/jpeg","creationDate":"2021-02-09T23:42:43Z","src":"https:\/\/images.unsplash.com\/photo-1612914033131-2fbd331a3806?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1OHx8ZGF0YSUyMGFuYWx5dGljc3xlbnwwfHx8fDE2NjM3NTgzMDc&ixlib=rb-1.2.1&fm=jpg&w=4000&h=6000&fit=max","width":4000,"height":6000,"id":"media\/unsplash:2w2NcgP3XNs","alt":"media\/unsplash:2w2NcgP3XNs","sizes":{"full":{"file":"media\/unsplash:2w2NcgP3XNs","sourceUrl":"https:\/\/images.unsplash.com\/photo-1612914033131-2fbd331a3806?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1OHx8ZGF0YSUyMGFuYWx5dGljc3xlbnwwfHx8fDE2NjM3NTgzMDc&ixlib=rb-1.2.1&fm=jpg&w=4000&h=6000&fit=max","mimeType":"image\/jpeg","width":4000,"height":6000},"large":{"file":"media\/unsplash:2w2NcgP3XNs","sourceUrl":"https:\/\/images.unsplash.com\/photo-1612914033131-2fbd331a3806?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1OHx8ZGF0YSUyMGFuYWx5dGljc3xlbnwwfHx8fDE2NjM3NTgzMDc&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:2w2NcgP3XNs","sourceUrl":"https:\/\/images.unsplash.com\/photo-1612914033131-2fbd331a3806?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1OHx8ZGF0YSUyMGFuYWx5dGljc3xlbnwwfHx8fDE2NjM3NTgzMDc&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:2w2NcgP3XNs","sourceUrl":"https:\/\/images.unsplash.com\/photo-1612914033131-2fbd331a3806?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1OHx8ZGF0YSUyMGFuYWx5dGljc3xlbnwwfHx8fDE2NjM3NTgzMDc&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:2w2NcgP3XNs","sourceUrl":"https:\/\/images.unsplash.com\/photo-1612914033131-2fbd331a3806?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1OHx8ZGF0YSUyMGFuYWx5dGljc3xlbnwwfHx8fDE2NjM3NTgzMDc&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:2w2NcgP3XNs","sourceUrl":"https:\/\/images.unsplash.com\/photo-1612914033131-2fbd331a3806?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1OHx8ZGF0YSUyMGFuYWx5dGljc3xlbnwwfHx8fDE2NjM3NTgzMDc&ixlib=rb-1.2.1&fm=jpg&w=340&h=510&fit=max","mimeType":"image\/jpeg","width":340,"height":510}},"attribution":{"author":{"displayName":"Mar\u00edlia Castelli","url":"https:\/\/unsplash.com\/@liacastelli?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4tptocw8ALDZNI1EvoZXoFcoQUER8QQUsd\/WW8GWIUmddhvBpjgAetIP67gEiigGe9AbVMnHsxsTbKj%2Bm%2Be3m5YWciW4qKUhqP%2BBhKLUYH5ozbIHPmqZ85aZz44jIPv46cgPdh9%2BUsXT8bCgfMdsEmH%2BTe\/aVVcmm2oJY72gAU5IkjJK0yJV9lRJoZm\/Q9KP6AJ2Zko79rkK%2BaxqAZI9osgbh5lj8gpwgj6ykOUpYS%2B6AIWKPNy7rFDICAc%3D"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.5}},"alt":"Weather Reporting System using IoT"},{"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":45,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":0.7,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false},"type":"text","content":"<span style=\"font-weight: 700; color: #ff4d6d\">What is Data Warehouse Architecture?<\/span>","fontWeight":700,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":10,"y":129,"width":381,"height":124,"scale":100,"focalX":50,"focalY":50,"id":"e0b5e198-22a4-4ccc-a9ce-b141e1326301","marginOffset":-33.45600000000001,"basedOn":"81b4f684-4af9-4c2f-80ef-3031feb0b986","groupId":null},{"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":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":null,"vertical":null},"type":"text","content":"<span style=\"color: #fff\">A collection of interconnected databases that allows data to be accessed, analyzed, and stored. It includes 3 main components; data warehouse, analytical framework, and integration layer.<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"width":317,"height":240,"scale":100,"focalX":50,"focalY":50,"basedOn":"a0259225-7078-482e-8257-f773446493c0","id":"71e82b17-746d-4d30-9fe6-72dfdfb24b08","x":48,"y":274,"groupId":null},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":0,"y":-39,"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":"b2be77de-d8eb-4607-b9f5-5c38341afa56","id":"d208d954-5f5f-45d5-bef2-69c1b08a4952"}],"animations":[{"id":"24e371db-eda8-4628-8f63-35b0cfa6b509","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["e0b5e198-22a4-4ccc-a9ce-b141e1326301"]},{"id":"1b0ed17a-b718-421b-a005-8c142f9224e4","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["71e82b17-746d-4d30-9fe6-72dfdfb24b08"]},{"id":"ce3a54f9-232b-4704-99ce-09ee91b0656f","type":"effect-background-zoom","zoomDirection":"scaleOut","duration":2000,"delay":0,"targets":["79aeaa82-5216-4611-a183-c2a200b7034f"]}],"backgroundOverlay":"none","backgroundColor":{"color":{"r":18,"g":32,"b":54}},"type":"page","id":"becbb31f-aa34-4058-b76e-6f59d68a9dae","pageTemplateType":"section","groups":[],"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":"8711ec8c-c179-493b-883f-6b3b31f32223","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/data-warehouse-architecture\/?utm_source=Ib&utm_medium=data-warehouse-architecture&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/06\/Cover-Data-Warehouse-Architecture.png","needsProxy":false,"ctaText":"Read More"}},{"elements":[{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":18,"y":245,"width":463,"height":245,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"e0704d42-fb83-49d1-8ef2-15b8d33eb223","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3","scale":100,"focalX":18.75,"focalY":50,"resource":{"baseColor":"#d9d9d9","blurHash":"LWFh^x9FD%kD~qV?MxbHS5t7V@n~","type":"image","mimeType":"image\/jpeg","creationDate":"2018-01-08T02:36:51Z","src":"https:\/\/images.unsplash.com\/photo-1515378960530-7c0da6231fb1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxsYXB0b3B8ZW58MHx8fHwxNjY1MzAwNzM4&ixlib=rb-1.2.1&fm=jpg&w=5616&h=3744&fit=max","width":5616,"height":3744,"id":"media\/unsplash:mfB1B1s4sMc","alt":"person sitting front of laptop","sizes":{"full":{"file":"media\/unsplash:mfB1B1s4sMc","sourceUrl":"https:\/\/images.unsplash.com\/photo-1515378960530-7c0da6231fb1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxsYXB0b3B8ZW58MHx8fHwxNjY1MzAwNzM4&ixlib=rb-1.2.1&fm=jpg&w=5616&h=3744&fit=max","mimeType":"image\/jpeg","width":5616,"height":3744},"large":{"file":"media\/unsplash:mfB1B1s4sMc","sourceUrl":"https:\/\/images.unsplash.com\/photo-1515378960530-7c0da6231fb1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxsYXB0b3B8ZW58MHx8fHwxNjY1MzAwNzM4&ixlib=rb-1.2.1&fm=jpg&w=4492&h=2995&fit=max","mimeType":"image\/jpeg","width":4492,"height":2995},"3369_2246":{"file":"media\/unsplash:mfB1B1s4sMc","sourceUrl":"https:\/\/images.unsplash.com\/photo-1515378960530-7c0da6231fb1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxsYXB0b3B8ZW58MHx8fHwxNjY1MzAwNzM4&ixlib=rb-1.2.1&fm=jpg&w=3369&h=2246&fit=max","mimeType":"image\/jpeg","width":3369,"height":2246},"2246_1497":{"file":"media\/unsplash:mfB1B1s4sMc","sourceUrl":"https:\/\/images.unsplash.com\/photo-1515378960530-7c0da6231fb1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxsYXB0b3B8ZW58MHx8fHwxNjY1MzAwNzM4&ixlib=rb-1.2.1&fm=jpg&w=2246&h=1497&fit=max","mimeType":"image\/jpeg","width":2246,"height":1497},"1123_749":{"file":"media\/unsplash:mfB1B1s4sMc","sourceUrl":"https:\/\/images.unsplash.com\/photo-1515378960530-7c0da6231fb1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxsYXB0b3B8ZW58MHx8fHwxNjY1MzAwNzM4&ixlib=rb-1.2.1&fm=jpg&w=1123&h=749&fit=max","mimeType":"image\/jpeg","width":1123,"height":749},"web_stories_thumbnail":{"file":"media\/unsplash:mfB1B1s4sMc","sourceUrl":"https:\/\/images.unsplash.com\/photo-1515378960530-7c0da6231fb1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxsYXB0b3B8ZW58MHx8fHwxNjY1MzAwNzM4&ixlib=rb-1.2.1&fm=jpg&w=340&h=227&fit=max","mimeType":"image\/jpeg","width":340,"height":227}},"attribution":{"author":{"displayName":"Christin Hume","url":"https:\/\/unsplash.com\/@christinhumephoto?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4tpeKJYts6e4nxj6qSLMmZntGKP2TyaU%2BUfLGw%2BmyqbLWJYm3LHNzfGOAKik6kicBAWoObZ5OrWQ7KSiOHb8tMUStl3LqX\/V5c9LklVSwZR0hBeJi7K6GJqErlPog%2By%2BWQ4fAgpKxmwX3HIrwOzKPNgXsvJVVRsdmFuYlWPLzN24lw7B4HnSxaeFIM035aPxAOgBnK1msvBRCGYnScbG2gDUPz1y%2B91lIHP4y1E%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":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":45,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":0.9,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":null,"vertical":null},"type":"text","content":"<span style=\"font-weight: 700; color: #ff4d6d\">Data Warehouse Architecture Properties<\/span>","fontWeight":700,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":11,"y":114,"width":391,"height":142,"scale":100,"focalX":50,"focalY":50,"id":"b8aeadef-a11d-459e-832e-54d819e58a56","marginOffset":-33.45600000000001,"basedOn":"a63faf4b-94e4-4c1c-8639-f84e29e25196","groupId":null},{"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":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":null,"vertical":null},"type":"text","content":"<span style=\"color: #fff\">1. Analytical and transactional processing should be kept separate.&nbsp;<\/span>\n<span style=\"color: #fff\">2. Maintain data security.<\/span>\n<span style=\"color: #fff\">3. Architecture should be able to be extended.&nbsp;<\/span>\n<span style=\"color: #fff\">4. Simple and straightforward should be the goal.<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"width":317,"height":272,"scale":100,"focalX":50,"focalY":50,"basedOn":"e5fd183e-3dbc-4fb1-958a-be04a3706844","id":"10a12e2a-8a3d-47a0-bb92-294a0c6e9cff","x":48,"y":265,"groupId":null},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":0,"y":-39,"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":"f54ed1a0-dd5c-4f79-8e2d-330c3379dcd9","id":"338f6295-642e-4f8b-a9ce-fba05457fb50"}],"animations":[{"id":"4eb240ea-fa3c-4eaf-9a83-a0482e2903c1","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["b8aeadef-a11d-459e-832e-54d819e58a56"]},{"id":"d02c37e2-403d-4f25-a8cc-290236e457a1","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["10a12e2a-8a3d-47a0-bb92-294a0c6e9cff"]},{"id":"a52eb94b-420a-4fce-8b21-ee6f2f97294a","type":"effect-background-zoom","zoomDirection":"scaleOut","duration":2000,"delay":0,"targets":["e0704d42-fb83-49d1-8ef2-15b8d33eb223"]}],"backgroundOverlay":"none","backgroundColor":{"color":{"r":18,"g":32,"b":54}},"type":"page","id":"277173cc-5715-49f8-a52a-cc1d7614dffc","pageTemplateType":"section","groups":[],"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":"97be699d-c148-4757-89c9-0b789dd4d4ea","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/data-warehouse-architecture\/?utm_source=Ib&utm_medium=data-warehouse-architecture&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/06\/Cover-Data-Warehouse-Architecture.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":"998a0474-d77b-4894-aa13-0655967a53c6","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#0c2626","blurHash":"LBEorfElXSNGBY0g=_IoKQ^*^hxu","type":"image","mimeType":"image\/jpeg","creationDate":"2019-11-30T05:00:10Z","src":"https:\/\/images.unsplash.com\/photo-1575089976121-8ed7b2a54265?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzfHxzb2Z0d2FyZSUyMGRldmVsb3BlcnxlbnwwfHx8fDE2NjYwOTE3Mzk&ixlib=rb-1.2.1&fm=jpg&w=4000&h=6000&fit=max","width":4000,"height":6000,"id":"media\/unsplash:VzJjPuk53sk","alt":"man using laptop","sizes":{"full":{"file":"media\/unsplash:VzJjPuk53sk","sourceUrl":"https:\/\/images.unsplash.com\/photo-1575089976121-8ed7b2a54265?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzfHxzb2Z0d2FyZSUyMGRldmVsb3BlcnxlbnwwfHx8fDE2NjYwOTE3Mzk&ixlib=rb-1.2.1&fm=jpg&w=4000&h=6000&fit=max","mimeType":"image\/jpeg","width":4000,"height":6000},"large":{"file":"media\/unsplash:VzJjPuk53sk","sourceUrl":"https:\/\/images.unsplash.com\/photo-1575089976121-8ed7b2a54265?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzfHxzb2Z0d2FyZSUyMGRldmVsb3BlcnxlbnwwfHx8fDE2NjYwOTE3Mzk&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:VzJjPuk53sk","sourceUrl":"https:\/\/images.unsplash.com\/photo-1575089976121-8ed7b2a54265?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzfHxzb2Z0d2FyZSUyMGRldmVsb3BlcnxlbnwwfHx8fDE2NjYwOTE3Mzk&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:VzJjPuk53sk","sourceUrl":"https:\/\/images.unsplash.com\/photo-1575089976121-8ed7b2a54265?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzfHxzb2Z0d2FyZSUyMGRldmVsb3BlcnxlbnwwfHx8fDE2NjYwOTE3Mzk&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:VzJjPuk53sk","sourceUrl":"https:\/\/images.unsplash.com\/photo-1575089976121-8ed7b2a54265?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzfHxzb2Z0d2FyZSUyMGRldmVsb3BlcnxlbnwwfHx8fDE2NjYwOTE3Mzk&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:VzJjPuk53sk","sourceUrl":"https:\/\/images.unsplash.com\/photo-1575089976121-8ed7b2a54265?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwzfHxzb2Z0d2FyZSUyMGRldmVsb3BlcnxlbnwwfHx8fDE2NjYwOTE3Mzk&ixlib=rb-1.2.1&fm=jpg&w=340&h=510&fit=max","mimeType":"image\/jpeg","width":340,"height":510}},"attribution":{"author":{"displayName":"Procreator UX Design Studio","url":"https:\/\/unsplash.com\/@weareprocreator?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4trhv93y8aUDa%2B6ydYl4Da250Dt\/jyxdGKd9xiSIg%2BdqOWUvxpwUFzs1FAKSaB16YgN9Ar2kmRyw8WUxaDppcBjY242oQS%2BFgZI63Isp%2BG54PHfZaf5hTNgku1FVqa7IITyZZ5zQXe58RAFkU%2BDRZnHciACRPKouncQHflHK%2BT%2BanLWyhqR54XsImCq7tb6abAJ88nDCJ9NeSl9AEtDoSRan3l%2BTKxbXoKfAAN%2Boji%2BOHqMZ3xeTr873qryOAMM\/"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.6}}},{"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":45,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":0.9,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":null,"vertical":null},"type":"text","content":"<span style=\"font-weight: 700; color: #ff4d6d\">Types of Data Warehouse Architectures<\/span>","fontWeight":700,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":11,"y":102,"width":391,"height":142,"scale":100,"focalX":50,"focalY":50,"id":"280702fd-a5f4-4b37-909d-e1d1b4c86a15","marginOffset":-33.45600000000001,"basedOn":"fd5ea70d-4822-4c48-9e40-c08bb42c67ac","groupId":null},{"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":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":null,"vertical":null},"type":"text","content":"<span style=\"color: #fff\">Single-layer structures are designed to keep data space to a minimum. They can be used for batch and real-time processing but are not implemented in real-life systems.<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"width":338,"height":206,"scale":100,"focalX":50,"focalY":50,"basedOn":"8255e0b1-21c3-433d-8b5a-3d960f385949","id":"84ea2df9-ceff-472a-bac3-cf281b1ff14a","x":38,"y":325,"groupId":null},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":0,"y":-39,"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":"857648ea-4943-4c85-b116-3dfd9b1f7cbb","id":"e427c56c-96f6-4181-8a6d-d3127a2566a3"},{"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":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"type":"text","content":"<span style=\"font-weight: 700; color: #fff\">Single-Tier Architecture<\/span>","borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":39,"y":272,"width":338,"height":35,"scale":100,"focalX":50,"focalY":50,"id":"56675ffb-1843-4e9e-b35f-ee2da85c3bd2"}],"animations":[{"id":"5e81af8b-1bc5-4458-a00d-a0a02da322a7","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["280702fd-a5f4-4b37-909d-e1d1b4c86a15"]},{"id":"ce9d43d9-54b3-44ca-9596-a05196311a3a","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["84ea2df9-ceff-472a-bac3-cf281b1ff14a"]},{"id":"45b9696b-609f-4f2d-aba1-d69521848f28","type":"effect-background-zoom","zoomDirection":"scaleOut","duration":2000,"delay":0,"targets":["998a0474-d77b-4894-aa13-0655967a53c6"]},{"id":"8626a36a-7e81-4399-ad61-5c65e40b4439","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["56675ffb-1843-4e9e-b35f-ee2da85c3bd2"]}],"backgroundOverlay":"none","backgroundColor":{"color":{"r":18,"g":32,"b":54}},"type":"page","id":"bc60c57e-a103-4417-900c-bd0d04f53aef","pageTemplateType":"section","groups":[],"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":"5fb1d4cc-7a4c-4873-bb38-46a02e3db33f","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/data-warehouse-architecture\/?utm_source=Ib&utm_medium=data-warehouse-architecture&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/06\/Cover-Data-Warehouse-Architecture.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":"13922a8c-9d16-438b-bf06-93ebb7d22548","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3","scale":100,"focalX":42.0556266524354,"focalY":50.06793410279936,"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=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&ixlib=rb-1.2.1&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=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&ixlib=rb-1.2.1&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=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&ixlib=rb-1.2.1&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=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&ixlib=rb-1.2.1&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=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&ixlib=rb-1.2.1&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=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&ixlib=rb-1.2.1&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=MnwxMzcxOTN8MHwxfHNlYXJjaHwyMnx8c29mdHdhcmUlMjBlbmdpbmVlcnxlbnwwfHx8fDE2NjI2MzI5MzM&ixlib=rb-1.2.1&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=ARX97wMOJMXa0uo3y5kR4JNv3ZZXWjDaHwfxD8TLku8DPrYyDhMVQVCHhh3UN8UcxojHwg2kUCif7FoJgyPW7sMKEkG6GbukKjTvuFMoTGgmBpuitk1VWC1nvSzsSo9jpHXTpHvd3nR%2BNzAJDQH0jKb%2B\/cYk5ClBwdQxDGTCm\/v6knvpf96HnyWw\/xN\/p44l11kNvdRHIA1dYFng9DIv20x6ypAhqFkSicP94UdOWIgYPJKWXEJxTdQeTDjdtYUWrBGT"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.6}}},{"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":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":null,"vertical":null},"type":"text","content":"<span style=\"color: #fff\">In this, analytical process is separated from business process, allowing for increased control and efficiency. The data can also be better understood, enabling more informed decisions.<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"width":342,"height":205,"scale":100,"focalX":50,"focalY":50,"basedOn":"8255e0b1-21c3-433d-8b5a-3d960f385949","id":"c3b82f1b-f33e-4c30-8ccf-11baeb3dc8a6","x":36,"y":290,"groupId":null},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":0,"y":-39,"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":"857648ea-4943-4c85-b116-3dfd9b1f7cbb","id":"ae498364-c80d-4848-9477-e6dcc4017a00"},{"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":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"type":"text","content":"<span style=\"font-weight: 700; color: #fff\">Two-Tier Architecture<\/span>","borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":40,"y":224,"width":338,"height":35,"scale":100,"focalX":50,"focalY":50,"basedOn":"56675ffb-1843-4e9e-b35f-ee2da85c3bd2","id":"54a0b92e-9f75-4f61-9272-be78f064d769"}],"animations":[{"targets":["13922a8c-9d16-438b-bf06-93ebb7d22548"],"id":"3a976783-20e2-4e32-ab73-06bf4198f9a8","type":"effect-background-zoom","zoomDirection":"scaleOut","duration":2000,"delay":0},{"id":"09d769b1-5688-4627-913c-754d3c10428b","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["c3b82f1b-f33e-4c30-8ccf-11baeb3dc8a6"]},{"id":"6e28b315-fe22-4803-877e-46584de2d057","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["54a0b92e-9f75-4f61-9272-be78f064d769"]}],"backgroundOverlay":"none","backgroundColor":{"color":{"r":18,"g":32,"b":54}},"type":"page","id":"f8edc689-b3b9-402a-bbe2-412ff0f6f60f","pageTemplateType":"section","groups":[],"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":"2a49e5fe-7400-41ee-bdd0-0620e4c26af0","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/data-warehouse-architecture\/?utm_source=Ib&utm_medium=data-warehouse-architecture&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/06\/Cover-Data-Warehouse-Architecture.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":213,"mask":{"type":"rectangle"},"isBackground":true,"type":"image","id":"2a49e5fe-7400-41ee-bdd0-0620e4c26af0","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#0c2626","blurHash":"L47^S,~WPB^j3rK*xuOWE0%2$fNF","type":"image","mimeType":"image\/jpeg","creationDate":"2020-11-14T18:46:54Z","src":"https:\/\/images.unsplash.com\/photo-1605379399843-5870eea9b74e?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&ixlib=rb-4.0.3&fm=jpg&w=3936&h=2544&fit=max","width":3936,"height":2544,"id":"media\/unsplash:SyvsTmuuZyM","alt":"black flat screen computer monitor","sizes":{"full":{"file":"media\/unsplash:SyvsTmuuZyM","sourceUrl":"https:\/\/images.unsplash.com\/photo-1605379399843-5870eea9b74e?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&ixlib=rb-4.0.3&fm=jpg&w=3936&h=2544&fit=max","mimeType":"image\/jpeg","width":3936,"height":2544},"large":{"file":"media\/unsplash:SyvsTmuuZyM","sourceUrl":"https:\/\/images.unsplash.com\/photo-1605379399843-5870eea9b74e?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&ixlib=rb-4.0.3&fm=jpg&w=3148&h=2035&fit=max","mimeType":"image\/jpeg","width":3148,"height":2035},"2361_1526":{"file":"media\/unsplash:SyvsTmuuZyM","sourceUrl":"https:\/\/images.unsplash.com\/photo-1605379399843-5870eea9b74e?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&ixlib=rb-4.0.3&fm=jpg&w=2361&h=1526&fit=max","mimeType":"image\/jpeg","width":2361,"height":1526},"1574_1017":{"file":"media\/unsplash:SyvsTmuuZyM","sourceUrl":"https:\/\/images.unsplash.com\/photo-1605379399843-5870eea9b74e?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&ixlib=rb-4.0.3&fm=jpg&w=1574&h=1017&fit=max","mimeType":"image\/jpeg","width":1574,"height":1017},"787_509":{"file":"media\/unsplash:SyvsTmuuZyM","sourceUrl":"https:\/\/images.unsplash.com\/photo-1605379399843-5870eea9b74e?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&ixlib=rb-4.0.3&fm=jpg&w=787&h=509&fit=max","mimeType":"image\/jpeg","width":787,"height":509},"web_stories_thumbnail":{"file":"media\/unsplash:SyvsTmuuZyM","sourceUrl":"https:\/\/images.unsplash.com\/photo-1605379399843-5870eea9b74e?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxMHx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&ixlib=rb-4.0.3&fm=jpg&w=340&h=220&fit=max","mimeType":"image\/jpeg","width":340,"height":220}},"attribution":{"author":{"displayName":"Fotis Fotopoulos","url":"https:\/\/unsplash.com\/@ffstop?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4to5KKKhfKm%2BEF66k9UwWEHb4mBPbNlrz6QTH3Jv9lgb5FuGLAXlOJVx7RIwJzUmIc6QQbjyDJ74yd7MCNsB6HV18sQevox9UJ4hH3PjUNItMWAndFl%2BF0UsRowxbEF\/cOwUrfiRIbeIEmB1N9qiGqKb77HB93v\/UF6UgvSbgHqX2EPYmf0aSDOZLDepGSywbKiMNz4oRgztIvcnszEAJ\/yAnLXWIgjRB%2BL0ms4Kk4iYWmrdrXpcsSAA0YGKtu61Cw%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":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":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":null,"vertical":null},"type":"text","content":"<span style=\"color: #fff\">It is employed in source layer, &nbsp;reconciled layer, and data warehouse layer. Reconciler sits between source data and data warehouse, and focus primarily on data integrity, and accuracy.<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"width":342,"height":205,"scale":100,"focalX":50,"focalY":50,"basedOn":"c3b82f1b-f33e-4c30-8ccf-11baeb3dc8a6","id":"ced126bf-3c38-43c6-a006-058a925018af","x":36,"y":290,"groupId":null},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":0,"y":-39,"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":"ae498364-c80d-4848-9477-e6dcc4017a00","id":"ac80a5e9-0bd3-45c9-a60e-bb31e15d12bd"},{"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":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":0,"vertical":0},"type":"text","content":"<span style=\"font-weight: 700; color: #fff\">Three-Tier Architecture<\/span>","borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":40,"y":224,"width":338,"height":35,"scale":100,"focalX":50,"focalY":50,"basedOn":"54a0b92e-9f75-4f61-9272-be78f064d769","id":"f5bb58eb-5acc-433d-81ca-fcd1271bf1c7"}],"animations":[{"id":"a796f6a5-2548-4909-895b-aaf3a7cde252","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["ced126bf-3c38-43c6-a006-058a925018af"]},{"id":"b14877e3-3c20-4187-b588-5881c9ad0962","type":"effect-background-zoom","zoomDirection":"scaleOut","duration":2000,"delay":0,"targets":["2a49e5fe-7400-41ee-bdd0-0620e4c26af0"]},{"id":"cc9f3fbc-422c-4a97-a72c-3f9f08d3e217","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["f5bb58eb-5acc-433d-81ca-fcd1271bf1c7"]}],"backgroundOverlay":"none","backgroundColor":{"color":{"r":18,"g":32,"b":54}},"type":"page","id":"c3b1d1c6-99fb-45e1-b62f-98e3c63d7827","pageTemplateType":"section","groups":[],"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":"7f65fa2e-141f-4c1f-b1c0-ae95b46214b6","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/data-warehouse-architecture\/?utm_source=Ib&utm_medium=data-warehouse-architecture&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/06\/Cover-Data-Warehouse-Architecture.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":"2a49e5fe-7400-41ee-bdd0-0620e4c26af0","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#260c0c","blurHash":"LXEoxy-:SgM{_N-ps-o0xut7axog","type":"image","mimeType":"image\/jpeg","creationDate":"2020-10-24T21:39:41Z","src":"https:\/\/images.unsplash.com\/photo-1603575448878-868a20723f5d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&ixlib=rb-4.0.3&fm=jpg&w=6000&h=4000&fit=max","width":6000,"height":4000,"id":"media\/unsplash:kylWNDQFd5A","alt":"man in black crew neck t-shirt using macbook","sizes":{"full":{"file":"media\/unsplash:kylWNDQFd5A","sourceUrl":"https:\/\/images.unsplash.com\/photo-1603575448878-868a20723f5d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&ixlib=rb-4.0.3&fm=jpg&w=6000&h=4000&fit=max","mimeType":"image\/jpeg","width":6000,"height":4000},"large":{"file":"media\/unsplash:kylWNDQFd5A","sourceUrl":"https:\/\/images.unsplash.com\/photo-1603575448878-868a20723f5d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&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:kylWNDQFd5A","sourceUrl":"https:\/\/images.unsplash.com\/photo-1603575448878-868a20723f5d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&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:kylWNDQFd5A","sourceUrl":"https:\/\/images.unsplash.com\/photo-1603575448878-868a20723f5d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&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:kylWNDQFd5A","sourceUrl":"https:\/\/images.unsplash.com\/photo-1603575448878-868a20723f5d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&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:kylWNDQFd5A","sourceUrl":"https:\/\/images.unsplash.com\/photo-1603575448878-868a20723f5d?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHwxOXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjA2&ixlib=rb-4.0.3&fm=jpg&w=340&h=227&fit=max","mimeType":"image\/jpeg","width":340,"height":227}},"attribution":{"author":{"displayName":"Anthony Riera","url":"https:\/\/unsplash.com\/@frenchriera?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4tqZwM467qCSjpjNUdXmIjsasRGaPc9Iha9CkP60pYqvaWLF8CFEhJesVh3JpOSM4cNQR431f9qYgEmLHzGdxDEqfzmF33aZjIVEzP4m4yfXxHqmuGi5kA1BcaVZ%2BZ2kQZqPk4XYQuzO3eUC7jCTK%2Bjdos7uyhCOS3SOjn4wlQV0QF6DQVoZjHKw7GqWyfKo6e0vO2YMIHFmXLSY9yUH\/EZwXjuNV8\/I952yUD5HHxiGnTcIUvndckrQ0KsLDysSpQ%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":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":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":null,"vertical":null},"type":"text","content":"<span style=\"color: #fff\">1. Speeds up Data Retrieving.&nbsp;<\/span>\n<span style=\"color: #fff\">2. Helps in error identification and correction.<\/span>\n<span style=\"color: #fff\">3. Support ETL processes.&nbsp;<\/span>\n<span style=\"color: #fff\">4. Enables real-time analytics.<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"width":342,"height":173,"scale":100,"focalX":50,"focalY":50,"basedOn":"ced126bf-3c38-43c6-a006-058a925018af","id":"4a3b6f89-51ac-4cf0-9a15-56afd82246b6","x":35,"y":334,"groupId":null},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":0,"y":-39,"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":"ac80a5e9-0bd3-45c9-a60e-bb31e15d12bd","id":"8a6e2793-4e01-4152-9b66-952d8b2d8dd3"},{"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":45,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":0.9,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":null,"vertical":null},"type":"text","content":"<span style=\"font-weight: 700; color: #ff4d6d\">Advantages of Data Warehouse Architecture<\/span>","fontWeight":700,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":11,"y":167,"width":391,"height":142,"scale":100,"focalX":50,"focalY":50,"marginOffset":-33.45600000000001,"basedOn":"280702fd-a5f4-4b37-909d-e1d1b4c86a15","groupId":null,"id":"fd765e85-fb99-4870-bbec-bdbaa7341ecc"}],"animations":[{"id":"fbe3b349-a415-40dc-b9f2-18d497031e95","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["4a3b6f89-51ac-4cf0-9a15-56afd82246b6"]},{"targets":["fd765e85-fb99-4870-bbec-bdbaa7341ecc"],"id":"46394eb2-232c-437f-bc2c-4d305cda9a61","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0},{"id":"5a603c43-422e-477c-bd0d-3b42622d17cd","type":"effect-background-zoom","zoomDirection":"scaleOut","duration":2000,"delay":0,"targets":["2a49e5fe-7400-41ee-bdd0-0620e4c26af0"]}],"backgroundOverlay":"none","backgroundColor":{"color":{"r":18,"g":32,"b":54}},"type":"page","id":"6a8b5715-a613-4b9b-b812-4e9eb036a638","pageTemplateType":"section","groups":[],"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":"b364d565-13cc-477a-962e-376a942173e9","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/data-warehouse-architecture\/?utm_source=Ib&utm_medium=data-warehouse-architecture&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/06\/Client-Server-Architecture-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":"2a49e5fe-7400-41ee-bdd0-0620e4c26af0","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#f3f3f3","blurHash":"LYNdH]?vTKROkrD%%2E1~qIUR5t7","type":"image","mimeType":"image\/jpeg","creationDate":"2019-11-07T22:31:26Z","src":"https:\/\/images.unsplash.com\/photo-1573165850883-9b0e18c44bd2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1NXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjU3&ixlib=rb-4.0.3&fm=jpg&w=4016&h=6016&fit=max","width":4016,"height":6016,"id":"media\/unsplash:kXfBDl0fR1E","alt":"woman in black blazer using MacBook","sizes":{"full":{"file":"media\/unsplash:kXfBDl0fR1E","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573165850883-9b0e18c44bd2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1NXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjU3&ixlib=rb-4.0.3&fm=jpg&w=4016&h=6016&fit=max","mimeType":"image\/jpeg","width":4016,"height":6016},"large":{"file":"media\/unsplash:kXfBDl0fR1E","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573165850883-9b0e18c44bd2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1NXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjU3&ixlib=rb-4.0.3&fm=jpg&w=3212&h=4812&fit=max","mimeType":"image\/jpeg","width":3212,"height":4812},"2409_3609":{"file":"media\/unsplash:kXfBDl0fR1E","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573165850883-9b0e18c44bd2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1NXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjU3&ixlib=rb-4.0.3&fm=jpg&w=2409&h=3609&fit=max","mimeType":"image\/jpeg","width":2409,"height":3609},"1606_2406":{"file":"media\/unsplash:kXfBDl0fR1E","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573165850883-9b0e18c44bd2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1NXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjU3&ixlib=rb-4.0.3&fm=jpg&w=1606&h=2406&fit=max","mimeType":"image\/jpeg","width":1606,"height":2406},"803_1203":{"file":"media\/unsplash:kXfBDl0fR1E","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573165850883-9b0e18c44bd2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1NXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjU3&ixlib=rb-4.0.3&fm=jpg&w=803&h=1203&fit=max","mimeType":"image\/jpeg","width":803,"height":1203},"web_stories_thumbnail":{"file":"media\/unsplash:kXfBDl0fR1E","sourceUrl":"https:\/\/images.unsplash.com\/photo-1573165850883-9b0e18c44bd2?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw1NXx8c29mdHdhcmUlMjBkZXZlbG9wZXJ8ZW58MHx8fHwxNjY2MzcwNjU3&ixlib=rb-4.0.3&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=AQBR4tp2phmBP\/OGrFM0\/nQaWr3LLFMZCulakQSzlZocePTuPjeIMafDqXYZcOnNmuZSDeGsvZ7HTEnklFWcMhXYCrHnegFouLykVP4aXc18GlducbqGDnwr9kZU700GTFwe8VJF299DUI8RQpHv9LsLC5Qf%2Bil1Le77HUoZgS\/bHXqwbgEhMF%2BylZ3o80WIdv3gz\/b2NTDJHjeTK9QKpFJJ\/JR5jXWLZ6SncjUn\/rZ4gnpYwd6Ya59nSqEAvZF4lgU6Eg%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":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":28,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":null,"vertical":null},"type":"text","content":"<span style=\"color: #fff\">1. Require a lot of maintenance.<\/span>\n<span style=\"color: #fff\">2.Hight maintenance costs.&nbsp;<\/span>\n<span style=\"color: #fff\">3. Automated extraction cannot guarantee data cleaning and validation.&nbsp;<\/span>\n<span style=\"color: #fff\">4. Hidden problems of data sources<\/span>","fontWeight":400,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"width":342,"height":240,"scale":100,"focalX":50,"focalY":50,"basedOn":"4a3b6f89-51ac-4cf0-9a15-56afd82246b6","id":"643f7bb3-7b41-450b-8e7c-10d46bd4c300","x":35,"y":291,"groupId":null},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":0,"y":-39,"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":"8a6e2793-4e01-4152-9b66-952d8b2d8dd3","id":"229e3eb4-2063-495d-b2e1-568c1c08318d"},{"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":45,"backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":0.9,"textAlign":"center","padding":{"locked":true,"hasHiddenPadding":false,"horizontal":null,"vertical":null},"type":"text","content":"<span style=\"font-weight: 700; color: #ff4d6d\">Disadvantages of Data Warehouse Architecture<\/span>","fontWeight":700,"borderRadius":{"locked":true,"topLeft":2,"topRight":2,"bottomRight":2,"bottomLeft":2},"x":10,"y":126,"width":391,"height":142,"scale":100,"focalX":50,"focalY":50,"marginOffset":-33.45600000000001,"basedOn":"fd765e85-fb99-4870-bbec-bdbaa7341ecc","groupId":null,"id":"4fee5d6f-1aa7-4932-873d-73eed814e976"}],"animations":[{"id":"2a03a204-7202-4a70-8688-b835fcb843d6","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0,"targets":["643f7bb3-7b41-450b-8e7c-10d46bd4c300"]},{"targets":["4fee5d6f-1aa7-4932-873d-73eed814e976"],"id":"a91af8fc-e1da-4561-bf74-0658688415a6","type":"effect-zoom","scaleDirection":"scaleIn","duration":2000,"delay":0},{"id":"e5c9c687-8a71-49f8-97ba-2333730a36fa","type":"effect-background-zoom","zoomDirection":"scaleOut","duration":2000,"delay":0,"targets":["2a49e5fe-7400-41ee-bdd0-0620e4c26af0"]}],"backgroundOverlay":"none","backgroundColor":{"color":{"r":18,"g":32,"b":54}},"type":"page","id":"3c95b9a9-c73a-49b1-af00-dfb2b4d04abc","pageTemplateType":"section","groups":[],"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":"e81b5c07-07cd-4bb5-bd92-e1da3330ab7d","basedOn":"baa9276c-1206-430d-b0a3-68699a42dee3"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/data-warehouse-architecture\/?utm_source=Ib&utm_medium=data-warehouse-architecture&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/06\/Cover-Data-Warehouse-Architecture.png","needsProxy":false,"ctaText":"Read More"}},{"elements":[{"x":48,"y":0,"width":330,"height":495,"type":"image","opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"mask":{"type":"rectangle"},"isBackground":true,"id":"d27e8c8f-9d92-46c4-b5fa-0dae2eeea7a3","basedOn":"5249418e-8fb7-46d7-8af1-835671d52f2b","scale":100,"focalX":50,"focalY":50,"resource":{"baseColor":"#f3f3f3","blurHash":"LgECqL~q?b.7%Mxuxut7WCWBRiRj","type":"image","mimeType":"image\/jpeg","creationDate":"2022-06-21T06:56:02Z","src":"https:\/\/images.unsplash.com\/photo-1655794387399-6dd29236eaa1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxhcmNoaXRlY3R1cmFsJTIwcGF0dGVybnxlbnwwfHx8fDE2NjYwODk2MzU&ixlib=rb-1.2.1&fm=jpg&w=4024&h=6048&fit=max","width":4024,"height":6048,"id":"media\/unsplash:fNW3Mix6F2Y","alt":"Architecture- contemporary","sizes":{"full":{"file":"media\/unsplash:fNW3Mix6F2Y","sourceUrl":"https:\/\/images.unsplash.com\/photo-1655794387399-6dd29236eaa1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxhcmNoaXRlY3R1cmFsJTIwcGF0dGVybnxlbnwwfHx8fDE2NjYwODk2MzU&ixlib=rb-1.2.1&fm=jpg&w=4024&h=6048&fit=max","mimeType":"image\/jpeg","width":4024,"height":6048},"large":{"file":"media\/unsplash:fNW3Mix6F2Y","sourceUrl":"https:\/\/images.unsplash.com\/photo-1655794387399-6dd29236eaa1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxhcmNoaXRlY3R1cmFsJTIwcGF0dGVybnxlbnwwfHx8fDE2NjYwODk2MzU&ixlib=rb-1.2.1&fm=jpg&w=3219&h=4838&fit=max","mimeType":"image\/jpeg","width":3219,"height":4838},"2414_3628":{"file":"media\/unsplash:fNW3Mix6F2Y","sourceUrl":"https:\/\/images.unsplash.com\/photo-1655794387399-6dd29236eaa1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxhcmNoaXRlY3R1cmFsJTIwcGF0dGVybnxlbnwwfHx8fDE2NjYwODk2MzU&ixlib=rb-1.2.1&fm=jpg&w=2414&h=3628&fit=max","mimeType":"image\/jpeg","width":2414,"height":3628},"1609_2418":{"file":"media\/unsplash:fNW3Mix6F2Y","sourceUrl":"https:\/\/images.unsplash.com\/photo-1655794387399-6dd29236eaa1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxhcmNoaXRlY3R1cmFsJTIwcGF0dGVybnxlbnwwfHx8fDE2NjYwODk2MzU&ixlib=rb-1.2.1&fm=jpg&w=1609&h=2418&fit=max","mimeType":"image\/jpeg","width":1609,"height":2418},"804_1208":{"file":"media\/unsplash:fNW3Mix6F2Y","sourceUrl":"https:\/\/images.unsplash.com\/photo-1655794387399-6dd29236eaa1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxhcmNoaXRlY3R1cmFsJTIwcGF0dGVybnxlbnwwfHx8fDE2NjYwODk2MzU&ixlib=rb-1.2.1&fm=jpg&w=804&h=1208&fit=max","mimeType":"image\/jpeg","width":804,"height":1208},"web_stories_thumbnail":{"file":"media\/unsplash:fNW3Mix6F2Y","sourceUrl":"https:\/\/images.unsplash.com\/photo-1655794387399-6dd29236eaa1?ixid=MnwxMzcxOTN8MHwxfHNlYXJjaHw0fHxhcmNoaXRlY3R1cmFsJTIwcGF0dGVybnxlbnwwfHx8fDE2NjYwODk2MzU&ixlib=rb-1.2.1&fm=jpg&w=340&h=511&fit=max","mimeType":"image\/jpeg","width":340,"height":511}},"attribution":{"author":{"displayName":"Paulina Milde-Jachowska","url":"https:\/\/unsplash.com\/@paulina_milde_jachowska?utm_source=web_stories_wordpress&utm_medium=referral"},"registerUsageUrl":"https:\/\/media3p.googleapis.com\/v1\/media:registerUsage?token=AQBR4tr3KneYhf6zRF%2BFSEZ%2BaCUai4g5M1uxYQCR7uMyKSiUtBrHYIfGPE6fLKCsrGG7fINafkSNGDOYwaATYfDBuJMuhY8%2B3muL0y3diPs5OYnVZlp3MmFXJvNdQTU\/w3JiPV0E7b5oC5onluIvJe5ZFPpMlD4UF\/\/A43TAo22ptBoFYZhhshANUI\/rOnKlZJOGYX\/VHm8aI7gn1rcgolYLK4EilHgQ0tDvfpQB267GQS%2B45PkLYjkCJH9e1gzCR4hd8b4ceQ%3D%3D"},"isPlaceholder":false,"isOptimized":false,"isMuted":false,"isExternal":true,"needsProxy":false},"overlay":{"color":{"r":0,"g":0,"b":0,"a":0.5}}},{"x":49,"y":145,"width":271,"height":375,"font":{"family":"Anton","fallbacks":["sans-serif"],"weights":[400],"styles":["regular"],"variants":[[0,400]],"service":"fonts.google.com","metrics":{"upm":2048,"asc":2409,"des":-674,"tAsc":2409,"tDes":-674,"tLGap":0,"wAsc":2876,"wDes":674,"xH":1500,"capH":1760,"yMin":-667,"yMax":2874,"hAsc":2409,"hDes":-674,"lGap":0}},"type":"text","opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"backgroundTextMode":"NONE","backgroundColor":{"color":{"r":196,"g":196,"b":196}},"lineHeight":1.2,"textAlign":"left","scale":100,"focalX":50,"focalY":50,"basedOn":"457c0ed6-69da-43c4-ac59-1d1359d980b9","id":"021e0541-35be-4946-80af-40b0a2d780a0","content":"<span style=\"color: #faf4ea\">For more information on data warehouse architecture, click here...<\/span>","fontSize":50,"padding":{"horizontal":0,"vertical":0},"tagName":"h2","marginOffset":-34.87060546875},{"opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"x":0,"y":-39,"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":"c651a1d2-88bb-443e-adda-4d1bdf3ad3ac","id":"d6783a38-6f55-44eb-b06c-5d94b750e921"}],"animations":[{"id":"2d535ce0-b1ea-4b59-9afe-33fb43378ce5","type":"effect-fly-in","targets":["021e0541-35be-4946-80af-40b0a2d780a0"],"flyInDir":"bottomToTop","duration":1000,"delay":0}],"type":"page","id":"b2cd7624-c3ec-4a7d-9867-d7d4dc8f0933","backgroundColor":{"color":{"r":33,"g":31,"b":30}},"pageTemplateType":"section","defaultBackgroundElement":{"x":21,"y":64,"width":128,"height":128,"type":"shape","opacity":100,"flip":{"vertical":false,"horizontal":false},"rotationAngle":0,"lockAspectRatio":true,"mask":{"type":"rectangle"},"isBackground":true,"id":"2458f4f8-cb5f-448c-b7b8-3c9ea6bf8aef","isDefaultBackground":true,"basedOn":"5249418e-8fb7-46d7-8af1-835671d52f2b"},"pageAttachment":{"url":"https:\/\/www.interviewbit.com\/blog\/data-warehouse-architecture\/?utm_source=Ib&utm_medium=data-warehouse-architecture&utm_campaign=webstories","icon":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/06\/Cover-Data-Warehouse-Architecture.png","needsProxy":false,"ctaText":"SWIPE UP"}}],"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":13739,"url":"https:\/\/www.interviewbit.com\/blog\/wp-content\/uploads\/2022\/10\/cropped-Data-Warehouse-Architecture.png","width":640,"height":853,"needsProxy":false},"_links":{"self":[{"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/web-story\/13735"}],"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":9,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/web-story\/13735\/revisions"}],"predecessor-version":[{"id":13757,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/web-story\/13735\/revisions\/13757"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/media\/13739"}],"wp:attachment":[{"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/media?parent=13735"}],"wp:term":[{"taxonomy":"web_story_category","embeddable":true,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/web_story_category?post=13735"},{"taxonomy":"web_story_tag","embeddable":true,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/web_story_tag?post=13735"}],"wp:lock":[{"embeddable":true,"href":"https:\/\/www.interviewbit.com\/blog\/wp-json\/web-stories\/v1\/web-story\/13735\/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}]}}