top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

INFORMATICA LOADING ERROR

+2 votes
2,443 views

I am new to informatica. I am using INFORMATICA 9.1.0 and oracle 11g as source and target database. I tried to create one table in target database and tried to load data from source to target. Table is getting created in target database. and I created mapping and workflow which is valid and i start work flow but it gave me following error.

Message Code RR_4036

Message

Error connecting to 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 help me with good solutions.

posted Apr 21, 2014 by Madhavi Kumari

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button
Please provide some more details.
How did you configure your relational connection ? Did you perform a test ?
Can you post your session log ?
commented Apr 21, 2014 by Raghvendra Sharma

1 Answer

+1 vote

I got solution:

Previously while creating remote connection in Relational Connection Editor for a session, In code page option I choose "UTF-8 encoding of unicode". Now changed to "ms windows latin 1 (ansi) superset of latin1" and I restarted the workflow which is succeeded.

The following video link shows how to create relational connection for a session and it helped

answer Apr 22, 2014 by Madhavi Kumari
Similar Questions
+2 votes
Database driver error when loading data with Informatica into Oracle XE 10 g

I'm trying to load within an Oracle XE 10g database. When I run an Informatica PowerCenter Workflow, I get a following error:

CMN_1022    Database driver error...
CMN_1022 [Database driver event...Error occurred loading library [pmora8.dll]. System error encountered is 193. Error text is %1 is not a valid Win32 application.
.]

Any ideas what might be causing this error? My environment is as follows:
•Windows Server 2008 R2
•Informatica PowerCenter 9.5
•Oracle XE 10 G

Powercenter repository is on SQL Server 2012.

+2 votes
Error while loading the data through informatica mapping

Can you please help me to find out solution for the below error message.

UTY4014 Access module error '34' received during 'set position' operation: 'pmUnxDskSetPos: fseek error (System error message detected: 29)'

Overview of the mapping: My Source is Oracle and Teradata, I am joining both the tables in my mapping and loading it into the teradata table.

Any suggestion?

+2 votes
Joining null in SQL Server, Oracle and informatica?

I have two tables to join with a column (say emp_id).. if emp_id in both the tables have null values, how will SQL Server and Oracle treat???

I read that informatica will neglect the NULL rows when joining..if I handle the null, by substituting -1, a cross-join will happen which i don't want..

What can I do here? (I cannot completely neglect the rows which has NULL)

+1 vote
Informatica: If session fails after loading 10000 records in the target, how can we load 10001 the record when run next?

If session fails after loading 10000 records in the target, how can we load 10001 the record when we run the session in the next time?

...