You can use ARC to specify a source staging database to partially move a non-PPI table or a view. This allows you to move a non-PPI table or view to a source staging table, then from the source staging table to the target system. To use a specified source staging table, you must set use_source_staging_table to true at the object level in the create XML file.
You can use DSA to specify a source staging database to move a partial table or view data.
Staging Database Name | Staging Database Name Result |
---|---|
Not provided at the table or database level | Created in the source database of the source tables. |
Provided at the database level | Created under the specified staging database on the source system, unless overridden at the table level. |
Provided at the table level | Are created under the specified staging database on the source system, even if a different staging database name is provided. |