Explicitly changing the metadata

pattemk · Post by **pattemk** » Mon Mar 25, 2013 1:50 am

Hi,

I have two fields COL1 and COL2 and the values are '2013-02-14' and '2013-02-21 10:15:45' respectively. (all records will be in this format only)

my job design:

SEQ FILE --> TRANSFORMER --> DATASET.

I am reading the two fields as varchar. Can i just change the output metadata in the transformer stage to 'Date' and 'Timestamp' respectively for the two fileds or should i require to use the type conversion functions?

Please advice

nikhil_bhasin · Post by **nikhil_bhasin** » Mon Mar 25, 2013 3:29 am

Yes you can do that, they will be implicitly parsed into the target datatypes, provided you are using transformer stage in between

chulett · Post by **chulett** » Mon Mar 25, 2013 9:55 pm

Continued here by the way.