What is an advantage of using watermark-based incremental loading over full table refreshes when ingesting from a source database into watsonx.data?
Select an answer to reveal the explanation.
Short Explanation and Infographic
Incremental loading with a watermark (e.g. a last-modified timestamp) extracts only changed rows; this is far more efficient than full extracts for large tables — reducing load on the source system and cutting ingestion time.
Full explanation below image
Full Explanation
Incremental loading with a watermark (e.g. a last-modified timestamp) extracts only changed rows; this is far more efficient than full extracts for large tables — reducing load on the source system and cutting ingestion time. The incorrect options ("Watermark loading converts all data types to VARCHAR for universal compatibility", "Watermark loading automatically handles schema changes in the source table", "Watermark loading compresses data in the source database before transfer") are distractors that don't fully capture the concept described.