How to find Last Record.

bhargav_dd · Post by **bhargav_dd** » Thu Jul 15, 2010 11:50 pm

Hi All,

I have a sequential file having some records say 20(This is not fixed it may change)..I need to get 20th record(last record of file) for loading into some other table..will that be possible with Transformer stage..if so how to do that..plss let me know if any of u have some solution..

Shaanpriya · Post by **Shaanpriya** » Fri Jul 16, 2010 12:15 am

Use tail stage to get the last 'n' number of records

ray.wurlod · Post by **ray.wurlod** » Fri Jul 16, 2010 1:50 am

In your case, the last 1 record, and the tail stage must run in sequential mode so that it only extracts one "last" record.

chulett · Post by **chulett** » Fri Jul 16, 2010 6:34 am

Please learn how to copy/paste properly so we don't continue to get crap like this in your posts:

Ask a Question DataStage| The DataStage group is for the discussion of technical issues that arise during the installation or daily administration of IBM InfoSphere DataStage software.
Home | Invite Peers | More Data Warehouse Groups

I've removed it (again) but it is getting to be a nuisance. There's a pefectly lovely 'Preview' button you should use before posting to make sure your post will look good, give it a shot. Please.

jonamg · Post by **jonamg** » Fri Jul 16, 2010 9:58 am

Use Execute Command Sequence afte the reading the file you can execute the command tail -1 'filename' in it.