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

Answers were Sorted based on User's Feedback



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

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

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

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

Post New Answer

More Informatica Interview Questions

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,


What are the new features of informatica 7.1?

2 Answers  


what are the limitations of pushdown optimization technique ? Advance thanks

3 Answers   Puma,


we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.

8 Answers  


What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 Answers  


What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers  


difference between informatica 8.1.1 and 8.6

0 Answers   TCS,


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  


What is rank transformation?

0 Answers  


What are the features of complex mapping?

0 Answers  


Is stop and abort are same in informatica?

0 Answers  


what is incremental aggregation ,with example?

2 Answers  


Categories