DSXchange

Hi All,

I constructed one job where my target table is my sql.

I am creating sarrogate key using skey stage col. name CL_ID and loading into the target table.

But i am getting below warning :-
In extended option of SKEY stage i have specified as "Unsigned".But still i am getting above warning.

Is there any way i can remove this warning without supress in log.


Thanks

PK

What about the Unicode property?
Have that set or unset in both the input as well as output.

You could specify unsigned integer in CL_ID, and incur a metadata mismatch instead. Better, of course, is to use an explicit conversion function. Worst case demote the warning using a message handler.

Hi Ray,

I have already specified CL_ID in SKEY as "UNSIGNED".It seems sarrogate key is creating CL_ID as "Unsigned" and on target table CL_ID is bigint which is signed.

If it is correct,is there any way i can create CL_ID in skey as Signed...??


Thanks

No. Surrogate keys are always generated as uint64. But you could change this downstream of the Surrogate Key Generator stage using, perhaps, a Modify or Transformer stage.

RAY's approach is perfect. If your project allowed , then you can handel it using message handler.

DS User

Hi All,

Thanks a lot for your replies. I feel instead of adding one more stage,we can handle it in Message Handler.

Lucky you don't work for me. That lazy approach would not be tolerated.