When a Router transformation processes many output groups in a mapping in advanced mode, allow data to persist by setting the Spark session property infaspark.sql.forcePersist=true in the mapping task.
When data persists, the Router transformation doesn't repeat read operations for each output group.