How to get the last record in a sur key state file
Moderators: chulett, rschirm, roy
How to get the last record in a sur key state file
Hi, anyone ever tried getting the last record in a surrogate key state file? I know I can use the sur key generator to view the file, but when I create a output link from the sur key gen stage I get all records in the file...only want the last value or record from the file and use it down stream. I know I can also use a transformer with logic of some kind to get the max, but wondering if there is an easier way that doesn't involve the transformer? Thanks for any help you can provide.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 48
- Joined: Wed Jun 01, 2005 7:10 am