how to fetch the last row from a particular column.. Input file may be sequential file...

Mallikarjuna_G

 Profile Answers by Mallikarjuna_G Questions by Mallikarjuna_G

• Aug 10th, 2013

There are multiple ways to do this, given that input is a sequential file. Two of them are

1. Use "Filter" option available in Seq file stage. Specify a unix command like: tail -1 (recommended)

2. Use a tail stage next to Seq filestage and then specify.

Akil

• Apr 1st, 2013

There are 2 ways to fetch the last row of any file if the number of records in the file is not known before run time:

1) Use the tail stage and run the tail stage in sequential mode
2) Use the lastrow() function in the transformer stage

Answer Question  Select Best Answer

Using server job, how to transform data in XML file into sequential file?? i have used XML input, XML transformer and a sequential file.

shm_Ariel

 Profile Answers by shm_Ariel Questions by shm_Ariel

• Jul 4th, 2008

Import the XSD for the xml file via manager-metadata importer and store it. If transformation functions are not required to be done on the data in XML file, there is no need for the tra...

dwh_com

 Profile Answers by dwh_com Questions by dwh_com

• Jun 24th, 2008

i will explain u the stages used inorder..FOLDER STAGE--------->XMLINPUTSTAGE--------->TRANSFORMER------>SEQUENTIAL FILEfolder stage is to check for the folder which has xmlfile and u have to...

Answer Question  Select Best Answer