Simple question about copy stage

Jag · Post by **Jag** » Thu Mar 31, 2011 1:01 pm

I've got a simple job i am creating and it involves conversion of a Numeric(14,0) to an Integer(10). Can i make this implicit conversion in a copy stage? I am working with whole number values with six digits. My job is running correctly but I am trying to understand if the copy stage can convert implicitly without using a function. If i dont end up using the copy stage i will be using the modify stage or a transformer stage, but i figured the copy stage would use the least system resources to process.

Thanks in advance and forgive my ignorance!

ajay.vaidyanathan · Post by **ajay.vaidyanathan** » Thu Mar 31, 2011 3:32 pm

Hi Jag,

You cannot achieve this using a Copy Stage because down the line it will create issues.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 31, 2011 3:49 pm

You can achieve any implicit conversion with any stage type that supports input and output links.

Note, however, that Numeric(14,0) does not implicitly convert to int32. Either use int64 on the output or Numeric (9,0) on the input.

soumya5891 · Post by **soumya5891** » Fri Apr 01, 2011 12:36 pm

You can use a modify stage with the following function

int64_from_decimal