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
Explicitly changing the metadata
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 50
- Joined: Tue Jan 19, 2010 4:14 am