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
- 17712 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 are limitations of joiner transformation?
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
Tell me about Propagate functions in informatica
What are the designer tools for creating tranformations?
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
Design a mapping to get year of join for each employee.
what is mapping parameter?
task is running successfully but data is not loded why?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
What is substr in informatica?
i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?
Teradata 
