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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use pmcmd utility command?

801


What is the difference between stop and abort in informatica

881


What are the main features of Oracle 8i with context to datawarehouse?

1885


explain one complex mapping with logic? sales project?

6424


How do we call shell scripts from informatica?

796


What are the informatica performance improvement tips

840


What is joiner transformation in informatica?

850


Name the different lookup cache(s)?

945


How many types of sessions are there in informatica.please explain them?

949


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1436


What is the different lookup cache(s)?

832


What is depict expression change?

821


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1710


How are the sources and targets definitions imported in informatica designer?

884


What's the layout of parameter file (what does a parameter file contain?)?

2192