Hi,
I'm loading data from a text file with data stage, this data has no really clear key column I can use. In the Oracle database where I put in the data I use a sequencer to create an id when writing the data in, but I would like to create a progressive variable earlier. Ok, e.g. there are systemvariables like inrow or outrownum, but I want that variable not only to live when the job is running, I want to store the last value and when the job runs next time he should run with the last value +1. Is this possible in data stage?
Thanks for advice,
Mario
How to create a progressional variable in data stage?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am