{"id":26291,"date":"2018-09-01T03:30:14","date_gmt":"2018-09-01T03:30:14","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=26291"},"modified":"2021-12-07T11:25:00","modified_gmt":"2021-12-07T05:55:00","slug":"qlikview-star-schema","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlikview-star-schema\/","title":{"rendered":"QlikView Star Schema – Viewing Table in Star Schema Model"},"content":{"rendered":"

In this QlikView tutorial, we are going to study a component of QlikView database management system<\/em>\u00a0called Qlikview Star Schema<\/em>. It is a way of representing and managing complex data sets comprising of more than one data files or tables. In this QlikView Start Schema tutorial, we will discuss how to view Star Schema.
\nSo, let us explore QlikView Star Schema.<\/p>\n

What is QlikView Star Schema?<\/h3>\n

QlikView star schema is a way of representing a data model which has a central fact table to which individual dimension tables are linked. It is a relational database model which represents a multi-dimensional database. It is called a star schema because the entity relationship diagram of the fact table and dimension table looks like a star.<\/p>\n

The QlikView star schema can range from being a simple five table star structure or can get as complex as having multiple fact tables attached to multiple dimension table making it a complex network of tables.
\nDo you know about QlikView Database Connection\u00a0& Inline data<\/a><\/strong><\/p>\n

The fact table usually contains measure fields and values, which are numeric values on which calculations can perform. While on the other hand, the dimension table as the name itself suggests contains descriptive text values known as dimensions. Each dimension in the fact table is linked to the respective dimension table with a unique key. Collecting all the keys of individual dimension tables, the fact table makes a primary key.<\/p>\n

QlikView star schema<\/em> model<\/em> is very significant as it helps in fast and efficient data processing and generating queries. It also makes comprehending complex data very easy for users as they get to visualize data in a well-structured manner. QlikView Star schema model is highly flexible and does not carry the limitations of a traditional OLTP system which slows down data processing. Professional developers also suggest structuring data in the star schema model for speed and efficiency.<\/p>\n

Viewing Star Schema in QlikView<\/h3>\n

Let us see how to view your tables in a star schema model. We have loaded sample data of sales records (CSV file) of a store and have created star schema for the same. We will guide you in doing it step by step.<\/p>\n

a. Loading Data<\/h4>\n

In the first step, we will load our dimension tables and fact tables into Qlikview memory.<\/p>\n

b. Order Dimension<\/h4>\n

This table has details of orders placed in the store. It contains descriptive field values like order ID and order date. Here, the unique key connecting this dimension table to the main fact table is Order ID.
\nTable. 1 QlikView Star Schema – Order Dimension<\/strong><\/p>\n

\"QlikView<\/a>

Order Dimension<\/p><\/div>\n

Learn about QVD Files and How to Create\u00a0them?<\/a><\/strong><\/p>\n

c. Customer Dimension<\/h4>\n

This table has customer details like customer ID and customer name (name of the customer who buy the respective products). Customer ID is the unique key.
\nTable. 2 QlikView Star Schema –\u00a0Customer\u00a0Dimension<\/strong><\/p>\n

\"QlikView<\/a>

Customer\u00a0Dimension<\/p><\/div>\n

d. Place Dimension<\/h4>\n

This dimension table contains details about the city and state of United States where the orders were delivered. Place ID is the unique key.
\nTable. 3 QlikView Star Schema –\u00a0Place Dimension<\/strong><\/p>\n

\"QlikView<\/a>

Place Dimension<\/p><\/div>\n

Let’s discuss the Major Properties of Documents in QlikView<\/a><\/strong><\/p>\n

e. Product Dimension<\/h4>\n
\"QlikView<\/a>

Product Dimension<\/p><\/div>\n

In this table there are details of the product that has been bought. Here, the unique key is Product ID.
\nTable. 4 QlikView Star Schema –\u00a0Product Dimension<\/strong><\/p>\n

Product Dimension<\/p>\n

f. Sales Fact Table<\/h4>\n

This table is a fact table as it contains all the unique key fields . It also\u00a0contains all Measure fields like sales, quantity, discount, profit which have all the numerical values.
\nTable. 5 QlikView Star Schema – Sales Fact Table<\/strong><\/p>\n

\"QlikView<\/a>

Sales Fact Table<\/p><\/div>\n

g. Script Loading<\/h4>\n

All these tables then loaded into QlikView script by INSERT option, then LOAD STATEMENT and then choosing the data file LOAD FROM FILE. Save the script. Reload it with CTRL+R.<\/p>\n

LOAD [Order ID],\r\n     [Order Date]\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\order details.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);\r\nLOAD [Customer ID],\r\n     [Customer Name]\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\customer details.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);\r\nLOAD [Place ID],\r\n      City,\r\n      State\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\Place details.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);\r\nLOAD [Product ID],\r\n     Category,\r\n     [Sub-Category],\r\n     [Product Name]\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\Product details.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);\r\nLOAD [Order ID],\r\n     [Customer ID],\r\n     [Place ID],\r\n     [Product ID],\r\n     [Sales ID],\r\n     Sales,\r\n     Quantity,\r\n     Discount,\r\n     Profit\r\nFROM\r\n[C:\\Users\\HP\\Desktop\\Dataflair\\Sales details.csv]\r\n(txt, codepage is 1252, embedded labels, delimiter is ',', msq);\r\n<\/pre>\n
Let’s explore What is QlikView Scripting & Features of Script Editor<\/a><\/strong><\/p>\n
h. Viewing Star Schema<\/h4>\n
In order to view the table structure in star schema press CTRL+T, once you have reloaded the new script. You will see your dimension and fact table arranged in a star-like structure with the dimension table connected with fact table with lines.<\/p>\n
\"QlikView<\/a>
Viewing Tables in QlikView\u00a0Star Schema<\/p><\/div>\n
So, this was all about QlikView Star Schema Tutorial. Hope you like our explanation.<\/p>\n
Conclusion<\/h3>\n
Hence, we studied QlikView Star Schema and how to view table in Star Schema. In addition, we discussed\u00a0the star schema in QlikView proves to a very useful method of visualizing and representing the data in a well-structured manner.
\nRelated Topic –\u00a0QlikView Careers Opportunities<\/a><\/strong>
\nFor reference<\/a><\/strong>
In this QlikView tutorial, we are going to study a component of QlikView database management system\u00a0called Qlikview Star Schema. It is a way of representing and managing complex data sets comprising of more than...<\/p>\n","protected":false},"author":6,"featured_media":26921,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[3235,8357,9328,9532,10165,11053,11065,11688,12664,13740,15383,15884],"class_list":["post-26291","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlikview","tag-customer-dimension","tag-loading-data","tag-order-dimension","tag-place-dimension","tag-product-dimension","tag-qlikview-schema","tag-qlikview-star-schema","tag-sales-fact-table","tag-script-loading","tag-star-schema-in-qlikview","tag-viewing-star-schema","tag-what-is-qlikview-star-schema"],"yoast_head":"\nQlikView Star Schema - Viewing Table in Star Schema Model - DataFlair<\/title>\n<meta name=\"description\" content=\"QlikView Star Schema Tutorial - What is Star Schema Model in QlikView, How to view table in Star Schema, Sales Fact Table, Script Loading, Order, Customer\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/qlikview-star-schema\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"QlikView Star Schema - Viewing Table in Star Schema Model - DataFlair\" \/>\n<meta property=\"og:description\" content=\"QlikView Star Schema Tutorial - What is Star Schema Model in QlikView, How to view table in Star Schema, Sales Fact Table, Script Loading, Order, Customer\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlikview-star-schema\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-09-01T03:30:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T05:55:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Viewing-QlikView-Star-Schema-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1202\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"QlikView Star Schema - Viewing Table in Star Schema Model - DataFlair","description":"QlikView Star Schema Tutorial - What is Star Schema Model in QlikView, How to view table in Star Schema, Sales Fact Table, Script Loading, Order, Customer","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/qlikview-star-schema\/","og_locale":"en_US","og_type":"article","og_title":"QlikView Star Schema - Viewing Table in Star Schema Model - DataFlair","og_description":"QlikView Star Schema Tutorial - What is Star Schema Model in QlikView, How to view table in Star Schema, Sales Fact Table, Script Loading, Order, Customer","og_url":"https:\/\/data-flair.training\/blogs\/qlikview-star-schema\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-09-01T03:30:14+00:00","article_modified_time":"2021-12-07T05:55:00+00:00","og_image":[{"width":1202,"height":630,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Viewing-QlikView-Star-Schema-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlikview-star-schema\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-star-schema\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"QlikView Star Schema – Viewing Table in Star Schema Model","datePublished":"2018-09-01T03:30:14+00:00","dateModified":"2021-12-07T05:55:00+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-star-schema\/"},"wordCount":819,"commentCount":1,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-star-schema\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Viewing-QlikView-Star-Schema-01.jpg","keywords":["Customer Dimension","Loading Data","Order Dimension","Place Dimension","Product Dimension","QlikView Schema","QlikView Star Schema","Sales Fact Table","Script Loading","Star Schema in QlikView","Viewing Star Schema","What is QlikView Star Schema?"],"articleSection":["QlikView Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlikview-star-schema\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlikview-star-schema\/","url":"https:\/\/data-flair.training\/blogs\/qlikview-star-schema\/","name":"QlikView Star Schema - Viewing Table in Star Schema Model - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-star-schema\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-star-schema\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Viewing-QlikView-Star-Schema-01.jpg","datePublished":"2018-09-01T03:30:14+00:00","dateModified":"2021-12-07T05:55:00+00:00","description":"QlikView Star Schema Tutorial - What is Star Schema Model in QlikView, How to view table in Star Schema, Sales Fact Table, Script Loading, Order, Customer","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-star-schema\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlikview-star-schema\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlikview-star-schema\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Viewing-QlikView-Star-Schema-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Viewing-QlikView-Star-Schema-01.jpg","width":1202,"height":630,"caption":"QlikView Star Schema - Viewing Table in Star Schema Model"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlikview-star-schema\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Troubleshooting Ambari","item":"https:\/\/data-flair.training\/blogs\/tag\/troubleshooting-ambari\/"},{"@type":"ListItem","position":3,"name":"QlikView Star Schema – Viewing Table in Star Schema Model"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/26291","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=26291"}],"version-history":[{"count":5,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/26291\/revisions"}],"predecessor-version":[{"id":105212,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/26291\/revisions\/105212"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/26921"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=26291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=26291"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=26291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}