Hi
I have populated my DIM_EMPLOYEE dimension which has 30 columns.
A new column needs to be added to the existing dimension and needs to be populated for all existing rows without dropping and re-creating the whole table.
How do I go about back populating only that one column for all existing rows?
Any suggestions
Thanks
zigzag 
(BOB member since 2009-09-13)
Is it a one time task?
Anyhow, the best thing will be to read the target table minus the extra column, lookup the additional column value and then load another target table. Once you are 100% sure the data is correct, truncate the original table and copy the data from the temp table.
Depending on the flow the task can be much simpler as well, e.g. if it is a target based CDC using TC transform, you simply add the column in the source, TC will find a difference and update the target.
Werner Daehn 
(BOB member since 2004-12-17)
Oh cool…
I have designed a target based CDC but wasnt sure if it would work in this case…
Many thanks Werner
zigzag (BOB member since 2009-09-13)