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 |
how i will stop my workflow after 10 errors
Explain informatica architecture - version 8 / 9
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?
What are the new features in Informatica 5.0?
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
Design a mapping to load the cumulative sum of salaries of employees into target table?
sample mappings for scd1,scd2 and scd3
In development project what is the process to follow for an etl developer from day1
Is it possible to use a client with different version than that of its Informatica server?
Can anyone tell me the new features in Informatica 9 Version?
What is a design?