After the table is created, the user can insert the corresponding values of each column (attribute) into the table by using the INSERT statement.

The general syntax for the Insert statement is following:

INSERT INTO table_name VALUES (value1, value2, ...)

In our ABC company example, the staff can insert the values into those tables he created by following methods:

INSERT INTO Product VALUES ('2','Throwback Cola', 'Pepsi', 'Pepsico','0', '0', 'soda', '12.01', '3.11', '8.9')

INSERT INTO Customer VALUES ('4', 'Julia Kennedy', 'Italian', 'Florida', 'Fivespan', 'Female', '30')

INSERT INTO sales VALUES ('8713', '366', 'CVS', '2013-01-01 00:06:30', '6', '77.94'), ('8713', '3263','7-11', '2013-01-01 00:09:52', '2', '19.94')
Insert the dimension table with the same key will overwrite previous data.