Page 1 of 1

Table Definition Update has not Taken Effect

Posted: Thu Sep 06, 2007 7:37 pm
by cosec
Hi,

I updated my table definitions for a certain table..Then using the usage analysis recompiled the referencing jobs...But the change has not taken effect...Have I missed out a step or should I manually set them up ?

Posted: Thu Sep 06, 2007 8:06 pm
by ray.wurlod
You've missed out on the step that involves updating the "internal" information pertaining to the relationship between table definition and job. In the Columns grid right click and choose to have the extra grid columns displayed, and in the Administrator (if you haven't done so already) check the box that allows editing of "internal" information.

Or you can simply re-import the table definition into the job(s), selecting (or not) the option to merge metadata with existing metadata.

Posted: Thu Sep 06, 2007 8:45 pm
by cosec
Thanks !!!