Table of Contents

Search

  1. About the Data Vault Administrator Guide
  2. Introduction to the Data Vault
  3. Data Vault Service Startup and Shutdown
  4. Data Vault Configuration
  5. Data Vault SSL Setup
  6. Data Vault ODBC Setup
  7. Data Vault Administration
  8. Data Repartitioning
  9. Partial Data Vault Copy
  10. Archived Data Migration
  11. Bulk File Uploader
  12. Data Vault Administration Tool
  13. Data Vault Logs
  14. User Account Privileges
  15. ssasql Command Line Program
  16. Data Vault Audit Log
  17. Sample Configuration Files

Data Vault Administrator Guide

Data Vault Administrator Guide

Data Import

Data Import

When you import the data in the target system, the ssadbcopy utility runs the DDL and administrator scripts on the target Data Vault system. You can append the data, or you can drop and create the data.
When you run the ssadbcopy command for data import, the utility performs the following high-level steps:
  1. The utility extracts the files from the TAR archive file to a temporary directory.
    You provide the full path of the TAR archive file and specify the location of the temporary directory in the command.
  2. The utility validates that all of the data files exist in the target system.
    The utility uses the data file list from the TAR archive to verify that all of the data files exist in the target data file directory.
  3. The utility runs the SQL, DDL, and administrator scripts from the TAR archive file.
    The utility creates the data structures. The utility registers the tables and data files in the Data Vault repository. For example, if you insert data in drop and create mode, the utility drops the data structure and unregisters the tables from the Data Vault repository.
  4. The utility validates the metadata of all new objects to verify that the partial copy is complete.

0 COMMENTS

We’d like to hear from you!