I am getting an error when I try to run a SDE mapping in Informatica.It gives me the following error:
Severity Timestamp Node Thread Message Code Message
ERROR 08/05/2013 5:51:21 PM node01_hrbiappd.cha.tva.gov READER_1_1_1 PR_18012 SQL Error [
ORA-00936: missing expression
Database driver error...
Function Name : Execute
When I try to run my Sql statement in SQL developer it works fine but its not working in mapping.I researched online and found out that it has to do something with parameter which is passing through DAC but I am unable to figure out where could be the reason.
Can anyone please help me with the error.
Thanks in Advance!!!
Add this values in Informatica overrideMpltVarWithMapVar
section 22.214.171.124 Setting PowerCenter Integration Services Custom Properties and if the above property is already added then check the DAC patch its should be mar 2013
mark if it helps