Staging Table

Transact-SQL
3

In my experience,I have always used staging tables when dealing with ETL tasks.
Loading data from flat files to staging table.
Then performing transformations on staging table while loading the data to the base tables.