Hi Experts,
I am generating sequence numbers by Transformer's Surrogate Key Option.Initial value is 1.
My requirement is:
Once the Surrogate key value reached to 1000,Then it has to start from Initial value.
Thanks in advance,
Phani
Surrogate key with cyclic option
Moderators: chulett, rschirm, roy
Mod(MySurrogateKey,1000)
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
There will gap in your sequence number if input records to your transformer stage is not evenly distributed to all nodes,that you have to make sure otherwise you need to run transformer in sequential mode.
There will gap in your sequence number if input records to your transformer stage is not evenly distributed to all nodes,that you have to make sure otherwise you need to run transformer in sequential mode.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
RPhani has mentioned that he is using "Transformer's Surrogate Key" i.e. as per my understanding he want to generate sequence in Transformer stage using surrogate key feature added in version 8x.
RPhani has mentioned that he is using "Transformer's Surrogate Key" i.e. as per my understanding he want to generate sequence in Transformer stage using surrogate key feature added in version 8x.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/