Search found 3 matches

by NeoInDS
Thu Oct 21, 2010 7:54 pm
Forum: General
Topic: Adding new column to target table
Replies: 7
Views: 1970

In Manager client click on table definition to select it then click on the Usage Analysis took (it looks like a beaker) in the toolbar. ... Hi Ray, Thanks once again but I don't think this feature is available in our version (no breaker icon in my toolbar and the 'Usage Analysis' option doesn't app...
by NeoInDS
Thu Oct 21, 2010 6:00 pm
Forum: General
Topic: Adding new column to target table
Replies: 7
Views: 1970

Welcome aboard. The technique you outline is valid. It might also be worthwhile performing a Usage (Where Used) Analysis on the table definition before modifying it, so you can be aware which other jobs touch it. Thanks so much, mate! Now I'm more confident to try out this solution. I don't think t...
by NeoInDS
Thu Oct 21, 2010 4:13 pm
Forum: General
Topic: Adding new column to target table
Replies: 7
Views: 1970

Adding new column to target table

Hi All, I am totally new to DS so please pardon my seemingly ignorant question... I am required to add a new column derivation to the target table of an already existing job using multiple data warehouse table lookups. My first take on this is as simple as adding a new column definition to my table ...