Interested to Buy Any Domain ? << Click Here >> for more details...
How to load the source table into flat file target(with
columns) in informatica?
- 4 Answers
- 17470 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
What is meant by pre and post session shell command?
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
how to connect two or more table with single source qualifier?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
HOW DO YOU CONNECT TO REMOTE SERVER ?
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
Informatica and datawarehousing courses in Pune?
What is data merging,data cleansing,sampling?
What is IQD file?
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
Teradata 
