top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

Import source definition in informatica

+1 vote
119 views

In Informatica, When I am trying to import a source definition from db (oracle data source) I get below error

[microsoft][odbc driver manager] the specified dsn contains an architecture mismatch between the driver and application

What I understood after doing some surfing is Informaitca is trying to access

C:\Windows\SysWOW64\odbcad32.exe

and not C:\Windows\system32\odbcad32.exe

When I try adding system/user data source (in C:\Windows\system32\odbcad32.exe), I am not able to see oracle.

Please help to get this issue resolved.

posted Jan 9, 2015 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

please try to update to new odbc driver its available for free download

answer Jan 13, 2015 by Shweta Singh
Similar Questions
+2 votes

For importing source/target tables, we can either go for importing them from DB/Flat Files/XML Files OR creating the table definition in informatica itself. I have couple of questions here -
•Whats the benifit of creating table definition manuallu in informatica over importing?
•How can we connect that created table definition to the corresponding data source which could be a DB/Flat file/XML etc.
•Please give a scenario where we create table definitions in informatica rather than importing.

Appreciate your interest.

+4 votes

For importing source/target tables, we can either go for importing them from DB/Flat Files/XML Files OR creating the table definition in informatica itself. I have couple of questions here -

• Whats the benifit of creating table definition manually in informatica over importing?
• How can we connect that created table definition to the corresponding data source which could be a DB/Flat file/XML etc.
• Please give a scenario where we create table definitions in informatica rather than importing.

+1 vote

I want to know how to rename the ODBC data source in informatica.

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...