Surrogate Stage or Transform Surrogate

[myukassign]

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

[ETLJOB]

I hope this post from Vincent should be good enough for your question.

viewtopic.php?t=95243&highlight=surrogate+key

[myukassign]

I hope this post from Vincent should be good enough for your question.

viewtopic.php?t=95243&highlight=surrogate+key

This wonn't answer my question. I basically know the various approches, but my question is different.

[Sainath.Srinivasan]

One activity - one stage.

To prepare surrogate keys, use "surrogate key stage".

The advantage of surrogate key stage is not only its use in multi-thread architecture but also in holding previous values and state files.

Also it provides better graphical annotation of activities in the canvas.

[myukassign]

Thats a good explanation....

I am happy with that.....

One Activity... one stage...

Thanks a lot ...