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.
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 <TableName>1 Exists, it will use <TableName>2 etc.
A structural copy of a table on the data warehouse also
contains the data movement information.