INFORMATICA LOADING ERROR -


i newbie informatica. using informatica 9.1.0 , oracle 11g source , target database. tried create 1 table in target database , tried load data source target. table getting created in target database. , created mapping , workflow valid , start work flow gave me following error.

message code rr_4036

message

error connecting database [ arun ora-00900: invalid sql statement database driver error... function name : executedirect sql stmt : arun oracle fatal error database driver error... function name : executedirect oracle fatal error ].

please me solutions.

i got solution this.

previously while creating remote connection in relational connection editor session, in code page option chose "utf-8 encoding of unicode". changed "ms windows latin 1 (ansi) superset of latin1" , restarted workflow succeeded.

the following video link shows how create relational connection session.

http://www.youtube.com/watch?v=om2d-ihfruw


Comments