Overview
A structural copy of a table can be useful in many scenarios. It can be used as a destination of a “Table Insert” on the staging area and it is very useful on the data warehouse level if you need a second copy of a table with many data movements for each field.
This feature enables you to create a structural copy of a staging or data warehouse table. The copy of the table will contain the same fields as the source table, however lookup fields are converted to regular fields and transformations are removed.
Process
Right click on the table you want to copy and select Copy Table Structure.
-
By default the copy of the table is named <TableName>1. If the name <TableName>1 already exists, the copy process will use the name <TableName>2 etc.
A structural copy of a table on the data warehouse also contains the data movement information.
Comments