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
- 17725 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 |
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
All active transformations r passive or not?
What is substr in informatica?
Can informatica load heterogeneous targets from heterogeneous sources?
Can we override a native sql query within informatica?
My source table having some records ,i want load 1st record and last record into one target?
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
How to elaborate powercenter integration service?
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
What are the connected or unconnected transforamations?
What is the difference between sequential batch and concurrent batch and which is recommended and why?
Teradata 
