Ask Search:
Rajsekhar BhattacharjeeRajsekhar Bhattacharjee 

how do i convert date to YYYY-MM-DDTHH:MM:SS.SSSZ through informatica?

I trying to load data into Salesforce though informatica 9.1 . My source file is csv(commadelimited excel). There I have the date in the form of  10/1/2012 8:08 .  In the target side the date format should be YYYY-MM-DDTHH:MM:SS.SSSZ. What should i do in order to achieve it?
 
Danny ReddyDanny Reddy
change the format either in the .csv file or in the feild that you are mapping. Make sure both are exactly in the same format, then try to upload it.