DSXchange

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

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

Continued here by the way.