How to design Star Schema Design for my Data Model

[#1]

Hi All,

Many of them recommended me to do Star Schema Design for my data model. Due to lack of experience in that and due to the insufficient experience in data model of the current project I am not able to initiate Star Schema design.

Can any one please help me out to initiate. I have attached the document which I am working. Hope that is good enough to work with.

[#2]

Hi Sunil,

SUNIL KUMAR PANDA wrote:
1>The data which is constant like.Dimension Tables(Customer_Table,Product_Table...Etc)
2>The varied tables like all type of transactions (Daily_sales_Reports,Daily_Transaction_Maintainance)<div></div>

Many thanks for you explanation! Can you please explain what do you mean by the term constant and varied??? These days I was thinking that all those tables which has from and to dates are called as fact tables. I need correct answer for this. Please correct me if I am wrong.

If you mean say that to make a fact table we need to join and concatenate then what I have to do in my case as chances are there that there will be a from and to date in those case. I that case I may not be able to join to make one fact. Let me know what have to do here.

[sunil2288]

HI Rikab,

I will suggest you to frequently query your client database manager he will guide you for design ing of the the structure..Data modeling is not a single day task..

Work in a team ..

It will solve your problem..

Regards,

Sunil

[#4]

Hi Sunil,

I am the only person which is working on qlikview in my company. Problem is that my manager who knows in and out of this database is always busy with some work. So he is not at all in a position to help me out. I know it takes lots are time to design the data model. As I don't have enough experience in doing the same I am not able to do it.

We don't have any team for qlikview. I am the only person who need to do all the work except the sql queries which was written by my manager.

Anyway leave it could you please answer me those questions which I asked in my previous post. It will help me some what.

Constant --> There won't be frequent changes in the data.

Varied --> There will always a changes in the data and also aggregate function are required to to summarize the data.(sales value,quantity value)

Please correct me If i am wrong. Sorry for my silly question as I am very new in this technology.

[sunil2288]

HI Rikab,

You are approaching correctly..

My Suggestion give sometime to understand the clients requirement and then design the fact table..in the fact table only the data need to be summarized will be present. and in the constant type of table all the dimension table will be present.

At all time the Dimension table's field will refer to the fact table for any summarization .

It's not a huge task ...

but approach steadily....

[#6]

HI Sunil,

Thanks for your reply! This project is not yet released. We are still working on it. There is no specific requirement from the client side. So could you please create the data model if time permits. Especially the fact table!

Did you look into my data model? In that there are several table with from and to date interval will that be a problem when I wants to design any model. What will be the case If there is more than one fact table. Which data model design I need to build? Please reply...