The Two Table Roll Up is used to denormalize two related tables to form a single table. Denormalization improves query performance and helps build a more effective physical model for a DBMS.
To roll up and denormalize two tables, please take the following steps:
1. Go to the menu View, select Toolbars, and check on Transformations.
2. Select the identifying relationship that connects the two tables
3. Press the Two Table Roll Up icon on the Transformations toolbar.
4. Use the Table Denormalization Roll Up Wizard to roll up the child table into its parent table.