New to SQL query

[john_hartman]

Dimension versus Fact Tables

The fact tables are usually aggregated and only list out IDs to map to the dimension tables. So an example fact table would show what vuln ids are on what asset id. If you wanted more info on the asset like it’s IP or Host name then that info would come from the dimension table dim_asset. If you wanted the name of the vulnerability that was found on that asset it would also come from a dimension table dim_vulnerability. So for your example, if you just wanted a count of how many critical vuln…