I have a file in UNix which has apostrophe or ` how can i replace them using informatica before loading into the table?
Use replacestr or replacechr funtion in expression to replace the ' symbol .
Hi Ram ,
you can achieve this by using Replacechar and replacestr functioins .
using Replacestr :
eg : input name is RAM`S
Replacechar and replacestr