How to normalize DATEs in Normalizer transformation?
Posted in the Informatica Forum
#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.
Add your comments below
|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|
Find what you want!
Search Informatica Forum Now
Copyright © 2016 Topix LLC