Hi,
In my job I have to generate surrogate key for records , my job also has a transformer stage to do some calcualtions.
Since traformer stage also give the functionality of generating surrogate key, is it required to use the surrogate key stage separatly.
Is it a good design/approach to make use of Transformer stage here than using surrogateket stage. Please advise
Surrogate Stage or Transform Surrogate
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 238
- Joined: Fri Jul 25, 2008 8:55 am
I hope this post from Vincent should be good enough for your question.
viewtopic.php?t=95243&highlight=surrogate+key
viewtopic.php?t=95243&highlight=surrogate+key
-
- Premium Member
- Posts: 238
- Joined: Fri Jul 25, 2008 8:55 am
This wonn't answer my question. I basically know the various approches, but my question is different.ETLJOB wrote:I hope this post from Vincent should be good enough for your question.
viewtopic.php?t=95243&highlight=surrogate+key
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 238
- Joined: Fri Jul 25, 2008 8:55 am