Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

"Dimension table" is the name for lookup tables in a star or snowflake schema.


TIL, Thanks.

'Landed table'? Is that the 'fact table', the one that contains the codes that need to be looked-up?


I'm pretty sure the landed table refers to the local copy of the original source. In an ETL* pipeline, the place where source data is stored for further processing is usually called the landing zone. Fact and Dimension tables are outputs of the process, whereas the landing tables are the inputs.

* in whatever order they're used




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: