Dragging Tables to Create Tables

When creating a table in a model, it is possible to drag the table from one schema to another schema within the tree.

1. Click on a table and drag it into the chosen schema in the tree. In the example below, we will drag table dim_customer from Version 1 into Version 2, thus creating a copy of the dim_customer table.
   
2. Complete the following:
   • Enter the Table name.
   • Select a Schema from the drop-down list.
   • Select Table type checkbox.
     
     Click OK.
3. The dim_customer table has now been copied into Version 2:
   

Dragging Columns to Add Columns

When adding a column to a table in the tree, it is possible to drag the column from one table to another table in the tree.

1. Click on a column and drag it into the other table in the tree.
   
2. The following dialog will ask you to confirm the addition of the selected column.
   
3. Click OK.
   The column has been added to the destination table.
   
   

   Note

   It is possible to drag more than one column at a time, as long as the columns are within the same table in the source system tree.

   

Dragging Tables into a Group

To create a group, refer to Groups for details.
To drag tables into the group, select the tables and drag them into the group in the tree.
 
A copy of each selected table is added to the group.