Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I think you should go from join here ,
tbUser
Left Join
tbuserpermission
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
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
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.
Thank you, i do have more then 2 Dim, I just "Zoom In" in this 2 tables
Thank you this was very helpful.