Hello Gurus,
when creating job for initial loading dimension tables, do we have to make surrogate key column for these dimension tables with surrogate key stage ?
or I guess if we can leave the creation of all surrogate key to the phrase of recurring loading .
thanks very much!
surrogate key in the initial loading
Moderators: chulett, rschirm, roy
This is more of a design question than a DS implementation one. Using a generated key from the beginning ensures that there are no duplicates and less "holes".
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I didn't say that these would occur, just that they could occur. If the initial load uses a different method from the recurrent one then there is a chance that the two methods won't synchronize (particularly after problems such as job aborts or retries with new data). If you only use one method then you have remove a potential source of error.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>