Please allow ads on our site
Kindly log in to use this feature. We’ll take you to the login page automatically.
LoginData warehouse star schema [closed]
Course Queries Syllabus Queries 3 years ago
User submissions are the sole responsibility of contributors, with TuteeHUB disclaiming liability for accuracy, copyrights, or consequences of use; content is for informational purposes only and not professional advice.
No matter what stage you're at in your education or career, TuteeHUB will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.
Similar Forum
Explore Other Libraries
Online Exams
Question Bank
Career News
Feeds
Full Forms
Dictionary
Interview Question
Gigs
Quotes
Lyrics
Videos
Courses
Blogs
Tutorials
Forum
Educators
Corporates
Tools
Please allow ads on our site
Kindly log in to use this feature. We’ll take you to the login page automatically.
Login
manpreet![Tuteehub forum best answer]()
Best Answer
3 years ago
I have a lesson called Data warehousing in there is a section called Star Scheme model
Can anyone explain the meaning of star schema in data warehouse concept, i tried in the net but i could't found any answer. its in my Degree syllabus but i cant understand it.
So, in my report/cubes i need to know (in a period):
1 How many Newsletter lead to a Sale,
2 How many Newsletter have been generated.
Where should i place the generate_date of Newsletter? If i place it in FACT table, but if this Newsletter did not lead to a Sale, there will be no date in FACT table.
If i place it on Newsletter and join it to Time, i would be breaking the Star schema?
How do i solve this :S
I have many other cases that is the same question, like client join_date.
Thanks