How can you create or import flat file definition in to the warehouse designer?

Question

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.

Answer 1

You can not create or import flat file definition in to warehouse designer directly. Instead U must analyze the file in source analyzer,then drag it into the warehouse designer.

When you drag the flat file source definition into warehouse designer work space, the warehouse designer creates a relational target definition not a file definition. If you want to load to a file, configure the session to write to a flat-file. When the informatica server runs the session, it creates and loads the flatfile.