how to fetch last row record

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
ssharmila
Participant
Posts: 17
Joined: Wed Jun 18, 2008 3:38 am

how to fetch last row record

Post by ssharmila »

how to fetch the last row of a particular column? what should be used? transformer or aggregator???
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Hmmm... somehow I'm guessing this isn't a TX question. Please repost it in the proper forum and then people will be happy to answer it.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
hari4dsx
Participant
Posts: 14
Joined: Wed Feb 13, 2008 4:53 am

Re: how to fetch last row record

Post by hari4dsx »

ssharmila wrote:how to fetch the last row of a particular column? what should be used? transformer or aggregator???

Well.....One way can be to use a transformer stage and generate a new column which will be made to store numbers in increasing order.i.e the column values will act as a row number.Then we can use an aggregator and pull the record with max row number.


I am not sure....how efficient this method is....

If anyone gets a better method please suggest.

Regards
hari4dsx
Hari
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

First suggestion would have been to wait for this question to reposted in the correct forum. However, since we've now gone down this road...

Moderator please move to the Server forum
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage TX”