How to load the source table into flat file target(with
columns) in informatica?

Answers were Sorted based on User's Feedback



How to load the source table into flat file target(with columns) in informatica?..

Answer / ganesh yadav

source->source.Qul->expres.Tran->target table
in the target desiner select target type as Flat File.

if u want only Header of the table with out data also we can do..

Is This Answer Correct ?    12 Yes 1 No

How to load the source table into flat file target(with columns) in informatica?..

Answer / srinivas

Seession Properties--> Mapping tab---> Target folder--->
Select the Target file --->Beside we will see
Tagetfilename.Filewriter in Properties.
one Property belongs to Header options.

From you can select your own style for Flat file only.

Any corrections pls let me know srinu.srinuvas@gmail.com

Is This Answer Correct ?    3 Yes 3 No

How to load the source table into flat file target(with columns) in informatica?..

Answer / ankit kansal

Hi,
Go to session properties and then select target instance from mapping there you will find an option where by default no header is selected just use output field names to provide your mapping column names or you can use command option to manually define your column.
Use echo col1,col2 to provide manual column names while selecting header command option.

http://www.allinterview.com/showanswers/122611.html

Is This Answer Correct ?    1 Yes 2 No

How to load the source table into flat file target(with columns) in informatica?..

Answer / madhavi

To load the source table and fact table by using import from databae or flat file

Is This Answer Correct ?    1 Yes 11 No

Post New Answer

More Informatica Interview Questions

Two Default User groups created in the repository are ____ and ______

2 Answers  


Enlist some properties of sessions.

0 Answers  


if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,


There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,


i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,






ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

3 Answers   HP,


What is a diff between joiner and lookup transformation

16 Answers   CTS, Satyam, TCS, UHG,


explain abt joiner t/r?

1 Answers   IBM,


What is meant by target load plan?

0 Answers  


How does a sorter cache works?

0 Answers  


What is a data modeling?

2 Answers  


How can we eliminate duplicate rows from flatfile,explain?

3 Answers  


Categories