How to generate only odd values/numbers in surrogate key gen

bond88 · Post by **bond88** » Tue Dec 03, 2013 12:35 pm

Hi,
Could anyone please suggest me how to generate only odd numbers as (1,3,5,....) surrogate keys ?

Thank you,

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Tue Dec 03, 2013 1:07 pm

Run them through a constraint where numbers evenly divisible by two aren't passed on.

Per numerous other posts - this does not guarantee that the generated numbers will hit every odd number in sequence (there will be gaps), just that only odd numbers will get through.

bart12872 · Post by **bart12872** » Tue Dec 03, 2013 1:41 pm

in a transformer, use
(@PARTITIONNUM*2+1) + ((@NUMPARTITIONS*2)*(@INROWNUM-1))