About Comparing DDL When Moving Underlying Data From a View - Teradata Data Mover

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.

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.