How to normalize DATEs in Normalizer ...

How to normalize DATEs in Normalizer transformation?

Posted in the Informatica Forum


Gurgaon, India

#1 Dec 8, 2009

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.

Tell me when this thread is updated:

Subscribe Now Add to my Tracker

Add your comments below

Characters left: 4000

Please note by submitting this form you acknowledge that you have read the Terms of Service and the comment you are posting is in compliance with such terms. Be polite. Inappropriate posts may be removed by the moderator. Send us your feedback.

Informatica Discussions

Title Updated Last By Comments
How to Handle Horizontal tab in Flat file in in... (Sep '15) Jul 15 ann_p 2
active and passive t/f Jul 15 ann_p 2
Loading a specific Erwin model version into Met... Apr '16 SCHJA26 1
not recognizing the source file (Jun '08) Mar '16 Jayashree 2
calling informatica powercentre workflow as a s... Mar '16 anil 1
Update Records Feb '16 beginer_informatica 1
First and last rec from flat file to table Feb '16 Nan 1
More from around the web