Sign Up for Training |
Jet Global Company Site
Submit a Request
Give Feedback

Create a Copy of Table Structure


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.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request