Copying a source to another warehouse source

You can copy a source table to another warehouse source.

Authorities and privileges

To copy a source to another warehouse source:

1. Open the Data Warehouse Center.

2. Click the plus sign next to the Warehouse folder.

3. Click the plus sign next to the Warehouse Sources folder.

4. Click the plus sign next to the warehouse source that contains the source you want to copy.

5. Click the plus sign next to the Tables, Views, or File folder.

6. Right-click the source that you want to copy.

7. Click Copy.

   A message prompts you to save the changes you've made to the process model. The Copy Source window opens.

8. In the Name field, type the name that you want the copy to have.

9. In the New warehouse source field, specify the name of the warehouse source that is to contain the source by selecting the name from the list or typing the name.

10. Click OK.

The source is copied to the warehouse source that you specified.

Related information

Defining a warehouse source table

Defining a warehouse source file

Warehouse source