U can not create or import flat file defintion in to warehouse designer directly.Instead U must analyze the file in source analyzer,then drag it into the warehouse designer.When U drag the flat file source defintion into warehouse desginer workspace,the warehouse designer creates a relational target defintion not a file defintion.If u want to load to a file,configure the session to write to a flat...

ASHOK1324

 Profile Answers by ASHOK1324 Questions by ASHOK1324

• Apr 18th, 2009

1] Add the metadata of source file into Informatica designer using source analyzer and save source file definition in the repository.2] When we drag the source file definition into warehouse desig...

Latha.

 Profile Answers by Latha. Questions by Latha.

• Sep 3rd, 2007

While creating flatfiles manually, we drag and drop the structure from SQ if the structure we need is the same as of source, for this we need to check-in the source and then drag and drop it into the Flatfile, if not all the columns in the source will be changed as primary keys.

Answer Question  Select Best Answer