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
- 17846 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 |
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How do you remove duplicate records in informatica? And how many ways are there to do it?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Which gives the more performance when compare to fixed width and delimited file ? and why?
what is target load plan
what is the difference between stop and abort
What are Dimensional table?
can we use cartesian join in informatica
In session log thier should not be a single error how will u do
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
What is the Rankindex in Ranktransformation?
Teradata 
