Stack Overflow
Stack Overflow

Questions tagged [staging-table]

Staging tables are used in data ETL (extraction transformation and loading) processes and data warehousing.

Staging tables are intermediate storage tables for storing data prior to loading into the main data warehouse. Staging tables schema have similar structure to the source table and are used reduce calls to the source table before loading into the main data warehouse.

18 questions
0
votes
1 answer

Copy table schema from DB2 to SQL Server

I'm looking at creating staging tables in SQL Server for one of our SSIS packages to reduce the number of calls to DB2 since calls to DB2 may experience timeouts when DB2 recycles inactive connections. Is there an automated method for copying table…
Cameron Tinker
  • 9,634
  • 10
  • 46
  • 85
-1
votes
1 answer

SQL Server staging table data type

I want to know what data type I should define in a staging SQL Server table when I don't know the exact data type of the source (csv files). What are the best practices for optimizing resource? Example: For text column: varchar(255) or…
SniperPro
  • 75
  • 1
  • 10
-2
votes
2 answers

Copying data from staging table to multiple tables

In SQL Server 2016 I have a staging table [S] with 8 columns. I want to copy that data to 3 tables [A], [B] and [C]. [A] has FK to [B] and [B] has FK to [C]. Columns 1-2 are to go to [c], column 3 to [a] and columns 4-8 to [B]. Can anyone tell me…
ComeIn
  • 1,519
  • 17
  • 12
1
2