About Comparing DDL When Moving Underlying Data From a View

Teradata Data Mover User Guide

brand
Analytical Ecosystem
prodname
Teradata Data Mover
vrm_release
16.10
category
User Guide
featnum
B035-4101-067K
When moving data from a view using copyData="true" you can compare the view columns with the columns of the target table using the compare_ddl feature.
The compare_dll feature is not used to compare the definition of the source and target views. It is used to compare the columns of the source view with the columns of the target table.
In order to compare the source view columns with the target table columns, the compare_ddl element needs to be specified as true. This is optional with a default value of true.
<views>
	<view selection="included" copyData="true">
		<name>deptsals</name>
		<database>MyDb</database>
		<view_data_table>
			<target_table>TargetTable</target_table>
			<target_database>TargetDb</target_database>
		</view_data_table>

		<staging_database>
			<name>TargetDb_Staging</name>
		</staging_database>

		<compare_ddl>true</compare_ddl>
	</view>
</views>
When copying view data, the compare_ddl element is not considered if the target data table does not exist on the target system or if copying view data to target view.