A number of different types of procedure generation are available. The procedure type is chosen from the procedure type drop down list. A set based procedure performs one SQL statement to join all the source tables together and then insert this data into the Data Store Object. This is normally the fastest method of populating a table.