Duration Data Type

Duration is specified in days, hours, minutes, seconds, and milliseconds. All the values must be integers. You must change the string data type that arrives from different source fields to a single string value and then map this string value to the duration data type in the target.

For example, when you configure a Data Synchronization task to read data from five different source fields of string data type, such as, 5 days, 10 hours, 21 minutes, and 35 seconds, you must concatenate the input string values to a single string value of comma-separated values, such as 5,10,21,35,0. You must then map the string output to the duration data type.