How can yoU create or import flat file definition in to the
warehouse designer?
Answer Posted / swetha
yoU 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
file. When the informatica server runs the session, it
creates and loads the flatfile.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is a stored procedure transformation?
What are the differences between oltp and olap?
Explain sql transformation in script mode examples in informatica
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Explain your project of banking domian.
What is informatica worklet?
How can informatica be used for an organization?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What do mean by local and global repository?
can we override a native sql query within informatica? How do we do it?
What is workflow? What are the components of the workflow manager?
Can we create two repositories on same database instance in oracle?
What is main use of mapplet?
What is repository manager?
How can we update a record in the target table without using update strategy?