Data Integration Performance Tuning > Optimizing mappings > Optimizing data preview
  

Optimizing data preview

Data preview performance depends on the number of rows that you preview. By default, the mapping previews 100 rows.
For sources that are larger than 1 GB, deselect both Read Entire Source and Enable Upstream Preview.