Default Date format
Posted: Mon Oct 24, 2016 3:27 pm
Hi,
I am using teradata table as my target ..I need to insert the date fields in the format "mm/dd/yyyy"
While writing to dataset I used varchar and assigned "mm/dd/yyyy"-- I am able to write data but I need to load the date fields in date format
What is the derivation to use in the transformer stage ?
Please let me know your input
Thanks
I am using teradata table as my target ..I need to insert the date fields in the format "mm/dd/yyyy"
Code: Select all
dataset ----->xfm -->Teradata
What is the derivation to use in the transformer stage ?
Please let me know your input
Thanks