Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Star Schema Model

Hey Community,

i have 2 table User & User Permission.

My goal is to create data model that based on  Star Schema. i would like your help what is he best way to do so.

Concatenate, Join, Left, Right.

P.s You can see that not all user have Permission But i want them to be in my model.

Erd.JPGUser.JPG

7 Replies
agni_gold
Specialist III
Specialist III

I think you should go from join here ,

tbUser

Left Join

tbuserpermission

Anonymous
Not applicable
Author

Hi Ben,

An star schema consist of a fact table and dimensions. Basically, a fact table contains values measured and the keys that connect to the dimensions to give meaning to that measures. On the other hand, a dimension is something like a catalog that contains attributes that describe and provide meaning to the fact.

There is another type of fact table called Factless fact table that doesn't contain any measure and are used to keep a track of relations between dimensions. For instance, if you need to track student attendance, you create a record every time a student attends a class.

Your star schema design, depends more on the business process that you're trying to model. In this case, what type of analysis do you want to perform? what data do you have available?, what is the level of granularity in your data?...the answer to this type of questions will help you to determine the design of your data model (star schema)...y recommend you to visit Kimballgroup.com for more information about techniques that you can use in your dimensional modeling design.

Regards,

-- Karla

engishfaque
Specialist III
Specialist III

Dear David,

Star schema can be combination of all the functions such as you mentioned.

Please look into listed below threads,

Re: Star & snowflake schema

Kind regards,

Ishfaque Ahmed

ajsjoshua
Specialist
Specialist

Hi,

I think this itself enough the datamodel is fine if you want you can left join the tables and make it single table.

Starschema is achieved if you hav 2 or more dimension tables,

Regards,

Joshua.

Anonymous
Not applicable
Author

Thank you, i do have more then 2 Dim, I just "Zoom In" in this 2 tables

Anonymous
Not applicable
Author

Thank you this was very helpful.