Surrogated key generator warning how to get rid off

times29 · Post by **times29** » Mon Nov 05, 2012 3:57 pm

Hi,
I am using Surrogated key generator as in oracle the datatype is number(8,0) . i am getting below warning so how can i fix this in SK generator without changing datatype in oracle?

conversion from source type "uint64" to result type "int32

Thanks

chulett · Post by **chulett** » Mon Nov 05, 2012 4:01 pm

From a search for your warning message:

viewtopic.php?t=133840

times29 · Post by **times29** » Mon Nov 05, 2012 4:51 pm

Thats what i did SK column bigint then transformer bigint still warning

chulett · Post by **chulett** » Mon Nov 05, 2012 5:13 pm

Then the warning isn't from the generator but rather from your target's attempt to squeeze a BIGINT into a NUMBER(8) field. At some point you will overflow that and the job will fail. However, in the meantime an explicit conversion may help, perhaps the DecimalToDecimal() function? Don't have any docs in front of me right now...

priyadarshikunal · Post by **priyadarshikunal** » Tue Nov 06, 2012 11:36 am

or might be the warning is different? are you sure it is same warning for same stage?

If you changed it to bigint then I expect a warning as
conversion from source type "uint64" to result type "int64"

or the same warning for the next downstream operator, please check the warning message again.