top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Import source definition in informatica

+1 vote
328 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
Whats the benifit of creating table definition manually in informatica (Source Analyzer) instead of importing

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.

+2 votes
Whats the benifit of creating table definition manually in informatica (Source Analyzer) instead of importing

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
Whats the benifit of creating table definition manually in informatica (Source Analyzer) instead of importing?

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.

+2 votes
How to Rename the ODBC Data source in Import tables->connect to database in informatica?

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

+1 vote
How to Rename the ODBC Data source in Import tables->connect to database in informatica?

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

...