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
mapping
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.