I am trying to normalize a data set -- using Informatica's Normalizer transformation -- that has 24 month's pivoted-up sales in it; now this transformation does not let DATE datatypes to pass through it. The only way I can think of using the normalization transformaiton is to first convert the Dates to Text before the normalizer, and then re-format Text as Dates after the Normalizer.

Please let me know if you know of a better way.