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

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

Question Posted / itsprasady

4 Answers
16156 Views
Accenture, I also Faced
E-Mail Answers

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