GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Informatica

 Print  |  
Question:  when we create a target as flat file and source as oracle.. how can i specify first rows as column names in flat files...



October 10, 2007 08:12:09 #8
 Mamatha   Member Since: Visitor    Total Comments: N/A 

RE: when we create a target as flat file and source as...
 
Hi,

   Create two file targets,the first target is loaded with the hardcoded column names and in the second file with actual values.In that particualr session there is a post session command in that we have merge the two file using unix cat command. so the format will be first row appears with all the column names and from second row it displays the actual values.

Regards
Mamatha
     

 

Back To Question