How to load the source table into flat file target(with
columns) in informatica?
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 the benefit of partitioning a session?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Where do we use mapping variables in informatica?
Explain the code page compatibility?
i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?
what is persistant cache in which situation we will use persistantcache
Explain factlessfact table with scenario
Why we need XMLs?
what is upstream and downstream transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is Data Caches size?
What is the advantage of persistent cache? When it should be used.