When you ingest data to a Hive target, you can propagate schema changes on the source to accommodate for schema drift in the relational database.
Schema drift occurs when you change the schema of a source table. For example, you might add new columns or change existing columns in the table. It can be a time-intensive task to revise the schemas of the target tables to match the schemas of the source tables before you perform each load of the data.
To accommodate for potential schema drift in the source tables, you can configure incremental loads to propagate schema changes on the source to the target. If the source tables have new columns or changes to existing columns, this option propagates the changes to the target tables.
The following image shows the property that you can use to propagate schema changes:
For more information about propagating schema changes, see the
Informatica PowerExchange for Hive User Guide
. Mass ingestion leverages the APPLYNEWSCHEMA target schema strategy.