top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+1 vote
241 views
How can you create or import flat file definition in to the warehouse designer?
posted Oct 20, 2015 by Sachin

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

1 Answer

0 votes

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.

answer Oct 20, 2015 by Manikandan J
Similar Questions
+1 vote

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.

...