Skip to Content

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.

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Mohammad 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?

    (0) 
  2. Carolyn Caster 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!

    Carolyn

    (0) 

Leave a Reply