How to load the source table into flat file target(with
columns) in informatica?
- 4 Answers
- 16823 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 |
In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process
How to delete first 3 rows & last 3 rows in target table in informatica
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
What is an expression transformation?
How to eliminate 1st and last rows from the source and load the inbetween rows.
how to get the first row without using rank t/r?
Define filter transformation?
What are the new features of informatica 9.x at the developer level?
When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
what is data driven in informatica
Teradata 
