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:
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.
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.
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.
The utility validates the metadata of all new objects to verify that the partial copy is complete.