Skip to Content
Author's profile photo Carolyn Caster

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.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Mohammad Shahanshah Ansari
      Mohammad Shahanshah Ansari

      Is this solution available for only multi user environment? What if somebody did the same mistake in local repo which is not associated with any central repo?

      Author's profile photo Carolyn Caster
      Carolyn Caster
      Blog Post Author

      Hi Mohd,

      I was able to do a quick test in my local repository, and it appears that the answer is yes, at least in our configuration.

      Thanks for your comment!