You can always reset the value of your key. So you can set any value you want, you can go back to one as well.
Simplest thing to do, is to have a process, which will find out the Max value of ID column. This value then in turn can be used to reset the SK.
IHTH.
Search found 118 matches
- Tue Apr 25, 2006 4:04 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Surrogate Key generation
- Replies: 7
- Views: 3609
- Tue Apr 25, 2006 9:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Running job in control M
- Replies: 16
- Views: 20337
Thank You Ken, that help. So in brief can I say : Depending on the number of jobs and complexity involved in trigerring the job one can opt for Sequencer or Scheduling Tool. The way we do it here is, before any development work, we come up with one common parameter list, which is used for all the jo...
- Tue Apr 25, 2006 9:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup fileset vs Dataset
- Replies: 8
- Views: 10314
Two issues I always face with Lookup Fileset: 1. How to view the data, that is loaded in the Lkp File Set. 2. You can not append data Secondly, unlike Hash File Lookup..the lookup stage lacks the capability of showing only the number of records that found match with the source, not sure if anything ...
- Mon Apr 24, 2006 9:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Running job in control M
- Replies: 16
- Views: 20337
Hello Ken, Just wanted to understand more on the point 'schedule a controlling Batch or Sequence job and let that manage the load effort '. What I have seen and I prefer is giving control to the Scheduling tool, that way it has control over all the jobs and easy to maintain. I do ot have to worry ab...
- Mon Apr 03, 2006 4:20 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: read_delimited() - row 2518,column, required column missing
- Replies: 4
- Views: 2774
- Tue Feb 28, 2006 11:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Regarding Join Condition
- Replies: 4
- Views: 2014
It depends on your tables.. Out of two tables can we say that one will have all the records for that key ? Or Keys are divided among two tables ? If its the first case, then you can use Inner Join or Even lookup stage, but if its the second scenario than you will have to do left or Right outer join....
- Tue Feb 28, 2006 11:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: time from string
- Replies: 13
- Views: 4848
- Tue Feb 28, 2006 11:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: time from string
- Replies: 13
- Views: 4848
- Tue Feb 28, 2006 11:32 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: time from string
- Replies: 13
- Views: 4848
- Tue Feb 28, 2006 11:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: null metadata
- Replies: 8
- Views: 2990
- Tue Feb 14, 2006 5:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Message handler
- Replies: 7
- Views: 3679
Message handler
If the warning are handled, using message Handler in One Environment will it create warnings in the new environment when you move your jobs?
I tried once, and I got the warnings in the new environment..is there anything specific one needs to do ?
I tried once, and I got the warnings in the new environment..is there anything specific one needs to do ?
- Fri Feb 03, 2006 12:24 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Abnormal termination of job: Throwing IDENT1 detected Error
- Replies: 6
- Views: 5298
- Fri Feb 03, 2006 12:19 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem in moving Hashfiles from one project to another proj
- Replies: 7
- Views: 4386
- Wed Feb 01, 2006 5:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookups in PX
- Replies: 1
- Views: 1417
Lookups in PX
Vincent Thank You For the information related to lookup performance. The Lookup fileset performance wise looks most of the time best option.. Few places where I struggle in using lookup fileset is, no ability to view the data and no option to append the data. Is there anything done regarding these i...
- Thu Aug 11, 2005 2:02 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: CREATE.INDEX
- Replies: 4
- Views: 2922