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 many ways you create ports?

1 Answers  


how can we run workflow with pmcmd?

3 Answers   Wipro,


What is DTM process?

4 Answers  


i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,


There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.

2 Answers   L&T,






i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,


How to load duplicate records in to a target table which has a primary key?

2 Answers  


How do you convert single row from source into three rows into target?

0 Answers  


without using rank transformation how can we rank items by using some other transformations

2 Answers  


what is parameter file?

1 Answers   Cap Gemini,


What is meant by target load plan?

0 Answers  


what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,


Categories