Full data load means that every dataset extracted from the data source is fully loaded into the landing or staging table. The process of full load has two variants. The first variant consists of the following steps:
- Content of landing or staging table is deleted or truncated
- Full dataset is extracted using SSIS or distributed query
- Extracted dataset is inserted into the table
Let's pay special attention to this list. In the first point, it is stated that the content of the table is deleted or truncated. Let's have a table simply named Landing.Products. This table contains the ProductKey, ProductName, and ListPrice columns. The table is placed in a database called DemoCust, created in an earlier example. Let's create this ...
