Good day sir. I would like to ask on how to include a dimension on a hierarchical design (recursion) to a fact? Kindly set an example and provide explanation if possible. Thank you.
If using SQL Server, use a common table expression. CTE. Recursion and RDBMS aren’t friends. Otherwise, you’re going to need an additional table to represent the relationship.
Good stuff! Thanks for the knowledge. I could learn something new on Kimball vs Inmon's approach from this video.
👍 thanks for the explanation
Thank you for the video.
Good day sir.
I would like to ask on how to include a dimension on a hierarchical design (recursion) to a fact?
Kindly set an example and provide explanation if possible.
Thank you.
If using SQL Server, use a common table expression. CTE. Recursion and RDBMS aren’t friends. Otherwise, you’re going to need an additional table to represent the relationship.
kimballll!
Informative and to the point explained. Please work on your Voice quality. Thanks for sharing your knowledge
Nice description, but voice is too low.
great information but audio is terrible
KIMBALLLLL!!!
Kimballlll!!! Deuce deuce deuce
Voice too low
anyone else here looking for Kim Kitsuragi
KIMBALLLLLLLLLL!
KIMBALLLLLLL!!!!!
KIMMMBAALLLLL
KIMBALLLLLL
You only mention the star schema, not the snowflake or the cube. Might want to look into that. Voice quality neeeds work.
It's a video about Kimball, not snowflake nor cube
Bad 🎤