About the Data Vault Administrator Guide
Introduction to the Data Vault
Data Vault Service Startup and Shutdown
Data Vault Configuration
Data Vault SSL Setup
Data Vault ODBC Setup
Data Vault Administration
Data Repartitioning
Partial Data Vault Copy
Archived Data Migration
Data Validation
Bulk File Uploader
Data Vault Administration Tool
Data Vault Logs
User Account Privileges
ssasql Command Line Program
Data Vault Audit Log
Appendix A: Sample Configuration Files
- ssa.ini
- nucleus.ini

Data Vault Administrator Guide

6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.4
- 6.4.3 HotFix 1
- 6.4.3

Back Next

ssapart Example

The following syntax shows an example of the ssapart command:

ssapart -t loyalty.ticket_coupon -c ID_NUM -n 2500 -m 4 -r c:\temp fas loyalty dba/dba

When you run the command, the Data Vault uses the connection fas
to connect to database loyalty
. The Data Vault uses column ID_NUM
in table ticket_coupon
in schema loyalty
to repartition the data. The Data Vault uses four parallel threads to repartition the data. Each data file includes 2,500 rows of data. The Data Vault stores the temporary files and log files in directory c:temp
.

Rename Saved Search

Table of Contents

Data Vault Administrator Guide

Data Vault Administrator Guide

ssapart Example

ssapart Example