image

Nigeria Since25 Jun, 2024
Click to expand
image
Posted By busola
3 months ago
fact table and dimension table

<p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt;">FACT TABLE</p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt;">A fact table is a central table that stores quantitative data for analysis. It typically contains facts (measurements or metrics) and foreign keys to dimension tables (will be explaine...

  • 0
  • 0
image
Posted By busola
3 months ago
Joins

Inner join is mostly used in mysql. And it only returns whatever is common in both tables under consideration 

  • 0
  • 0