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..

Answer / srinivas

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

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

Answer / madhavi

To load the source table and fact table by using import from databae or flat file

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

0 Answers  

---

in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers   HCL, Thomson Reuters,

---

Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

2 Answers   TCS,

---

how can import the data from the flat files?

2 Answers  

---

What is meant by active and passive transformation?

0 Answers  

---

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

2 Answers   TCS,

---

Why is meant by direct and indirect loading options in sessions?

4 Answers  

---

Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai

1 Answers   Infosys, Saksoft,

---

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

Plz can any one say me how to get the informatica certification materials and dumps

0 Answers   TCS,

---

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers   Accenture,

---

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how

7 Answers   TCS,

---