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

 Print  |  
Question:  Whats the best way in a AI GRAPH to read the header 1st line and trailer (last line) in a i/p file, compare record counts and checksum (available in header) and error out if actual recd count or checksum did not match?



August 08, 2006 06:47:20 #1
 bhanu   Member Since: Visitor    Total Comments: N/A 

RE: Whats the best way in a AI GRAPH to read the heade...
 

we can use run compononent in the parameters tab for commandline give unix AWK command for skipping the specified record num

awk '{if(NR!=1  && NR!=2) print $0}' this we can use for first record

or else we can use onemore component read seperated value in the parameters tab u can specify skipheader as true

This is upto my knowledge

Thanks

Bhanu

     

 

Back To Question