My Template Table Became ‘Permanent’, and I Want to Change it Back

On our project, the innocent actions of a team member resulted in my template table being converted into a permanent one, and since it was used in many data flows, I couldn’t just right-click/delete it away. Instead, I searched for online help, but found none but experimented with the following steps, which worked for me:

1-      Check out the permanent table. From the ‘Central Object Library’ window, right-click, check out.

2-      In Designer, in the datastore area of your ‘Local Object Library’, right-click, delete the permanent table you just checked out.

3-      Now, remove the same permanent table from your data flow in Designer, and replace it with a new template table that you’ll create with the exact same name and db (TRANS, STAGE, etc) as the permanent table had. The name is very important, it must be exactly the same. Exactly.

4-      Save, check, test your data flow.

5-      Check in the permanent table. From the ‘Central Object Library’ window, right-click, check in. You should see the permanent table disappear from the ‘Tables’ list, with the table instead appearing in the ‘Template Tables’ list.