If you have column name as f_name in which the data is "john&","97edward","do__nna" . you want to remove/replace the special characters and then send the output as "john","edward","donna" to the target. what is the transformation and what is the function to be used in the mapping(informatica)

It can be possible by using %a in Session Components POST SESSION EMAIL tab.

I am getting this error "ORA-14050: invalid ALTER INDEX MODIFY PARTITION option" while running a procedure through informatica session. But the same procedure is executed successfully and doing the expected ,while executing in PL/SQL. The output of this proc comes like this ALTER INDEX MODIFY PARTITION < PARTITION_NAME> UNUSABLEIs there any specific syntax for executing alter index option through...