How can yoU create or import flat file definition in to the
warehouse designer?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / gayatri
u can create or import ff into target defination designer
too select target designer-> create-> geve ff name and
select database type select flat file option can create this
way.
| Is This Answer Correct ? | 0 Yes | 0 No |
list out all the transformations which use cache?
How you count the number of records available at your source?
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
Explain the pipeline partition with real time example?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?
6 Answers iFlex, Morgan Stanley,
Explain direct and indirect flat file loading (source file type) - informatica
Why do we use DSS database for OLAP tools?
What are the tasks that Loadmanger process will do?
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
in which situations do u go for scds ?