title: how to implement looping in infromatica also what its performance
body: <p>I wonder how to implement a loop on cursor in Informatica 10.4.1 also what will the performance be if it will be very bad with very large data? as I need to migrate an SQL procedure from SQL-server to Informatica to run on apache spark</p>
  <p>I found multiple old articles talk about to make parent and child workflows in which the parent called the child with a control table using processed_flag, but I need an easier design with the best practice to get good performance with a large number of rows.</p>