When partition column is present in source data and same column is configured in truncate partition | It allows partition column in source data and respect source partition column value | Job will failed if partition column is found in source data and same partition column is configured in truncate partition section. To prevent this situation, user has to manually exclude partition column from source. |
When subset of partition columns are configured in truncate partition section for hive technology | It allows subset of partition columns in truncate partition section | Job will failed if subset of partition columns are configured in truncate partition section. To prevent this situation, user has to configure either all partition columns or none partition columns. This applies only for hive technology. For delta technology, user can configured subset of partition columns in truncate partition section. |
When truncate partition section is not configured for hive technology. It will result into different output. | It truncates full target table and insert source data in target table | It will not truncate full target table. It will truncate only those partitions for which source contains data. Other partitions data will remain intact. |