1.

How Can You Create Or Import Flat File Definition Into The Warehouse Designer?

Answer»

You cannot create or import flat file definition in to warehouse designer directly. INSTEAD you 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 WORKSPACE, 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 flat file.

You cannot create or import flat file definition in to warehouse designer directly. Instead you 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 workspace, 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 flat file.



Discussion

No Comment Found