Joins in SQL are used to combine two or more tables. It returns the matching rows from the combined tables by using reference column in both the tables. Types of Joins: Inner Join: Inner join or Equi-join, returns rows from the both the tables based on the matching values of the columns. Example: Below we […]
Other Tips
Business Intelligence Basics – Dimension and Fact
What is a dimension/dimension table In Data warehousing, dimension table contains the textual or descriptive attribute of the data. For example customer dimension will contain details about customer’s name,address,phone number etc. Dimensions are used to slice and dice the data i.e. filter and group the data.Dimension table also help you by looking at data with […]