Modify Stage - Conversion

[devidotcom]

Hi,

Please help in converting a source field of datatype NVarchar(120) Nullable to target field of decimal(120) Not Nullable using a modify stage.

Thank you.

[chulett]

What exactly would a Decimal(120) be?

[ray.wurlod]

The function is decimal_from_ustring but, like Craig, I am puzzled about precision 120 on a decimal field.

[wfis]

Oops. Thanks for the reply.

Yes its from NVarchar(120) to Decimal 8
I am sure the source data will hold not more than 8 chars from the source based on one filtering criteria. How do we eliminate the warnings it throws any due to this.

Thanks

[ray.wurlod]

What warnings are these?

Do you have a NOWARN specification in your Modify stage? (These are really about nullability warnings, so I doubt that they'd be legitimate here.)

Is there any reason you can't use NVarChar(8) as the input data type - possibly derived upstream using a substring operation?

[vmcburney]

The warnings are telling you your code is not robust. You are converting NVARCHAR to decimal - what happens to non numerics in that field? You are converting nullable to NOT NULL which means you will lose rows if a null is encountered. I would convert this in a Transformer instead with a NullToValue followed by a Decimal check followed by the conversion and a reject link for those rows that do not work. Transformer will let you do validation in a stage variable and nested conversion in a cell.

[ray.wurlod]

Or a Modify stage using handle_null() !

But there's no Modify stage equivalent of the IsValid() function.