Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Congratulations to the new Qlik Luminary and Partner Ambassador class! Meet them here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
AH3
Contributor
Contributor
‎2022-02-01 04:01 AM

STAR SCHEMA

Hi,

I'm a student and quite new to Qlik and I was wondering if someone could help me
with my star schema. This is my datamodel and I've tried to make the star schema but I'm not sure which approach is correct.

(It's a tracking system to follow a certain visitor. Each visitor is from a certain company and gets  a tag so that he can be tracked at which kiosk/stand he is at a certain moment.) 

datamodeldatamodelTest1Test1Test2Test2

1,620 Views
0 Likes
1 Reply
vikasmahajan
MVP
MVP
‎2022-02-01 04:27 AM

Looks Like Test2 approach is correct  which is having one to one  connection  fact->dimension :

refer: https://www.guru99.com/star-snowflake-data-warehousing.html

Vikas

 

 

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
1,593 Views
0 Likes