Why Does a Data Import Create More Rows Than the Source File Contains?

Imports can expand records when joins match multiple reference rows, retries replay data, or one source row intentionally maps to multiple outputs.

What to check

Compare input and output counts by batch ID, inspect join cardinality and duplicate keys, and check retry and merge behavior. Trace a few expanded records back to their source rows.

Recommended next step

Define expected cardinality and deduplication rules, then rerun only with an idempotent process. Informatix Systems can investigate data pipelines and improve validation.