Search found 4605 matches
- Wed May 04, 2005 9:53 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Can we replace hashed files using the UniVerse DB Stage?
- Replies: 2
- Views: 965
Yes. Hash files can be built with hash file stages and then accessed with UV stages. The difference is UV stages use SQL to select and update where hash file stages read and write in a more native method. Hash file stages should be faster. You can do things like multiple row lookups only with UV sta...
- Wed May 04, 2005 9:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: hashed file
- Replies: 6
- Views: 2069
Most of us use hash files to do all the lookups. Most use surrogate keys in all target tables. You will need to to build cross reference hash file lookups meaning the hash file has the old source key as the hash file key and it stores the surrogate key as a regular (not key) field. Does that make se...
- Wed May 04, 2005 9:09 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Need info about uv command
- Replies: 10
- Views: 2542
- Wed May 04, 2005 9:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Need info about uv command
- Replies: 10
- Views: 2542
The uv command is supposed to work in an account directory. An account is defined by 4 files VOC, VOCLIB, D_VOC and D_VOCLIB. If these files do not exist then it will create a new account. Universe has the ability to emulate other versions of Pick or Prime Information. All projects are setup as Idea...
- Wed May 04, 2005 5:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multiple server version in same host
- Replies: 5
- Views: 1967
- Tue May 03, 2005 6:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CPU performance maxing out in Designer
- Replies: 5
- Views: 1326
- Tue May 03, 2005 2:37 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: hashed file
- Replies: 6
- Views: 2069
- Tue May 03, 2005 2:35 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: pass values to job parameters in a sequencer
- Replies: 16
- Views: 5180
- Tue May 03, 2005 2:33 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multiple server version in same host
- Replies: 5
- Views: 1967
- Tue May 03, 2005 7:52 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage Hashed File Calculator
- Replies: 8
- Views: 3065
- Tue May 03, 2005 7:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage Hashed File Calculator
- Replies: 8
- Views: 3065
If you wish to use static hash files and not dynamic then it will help you select a modulo. I never use static hash files not worth the effort. Someone needs to maintain them and understand them long after I am gone from the project. Even worse is they can exist and be sized poorly and killing your ...
- Tue May 03, 2005 7:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage has a new name!
- Replies: 9
- Views: 2662
- Tue May 03, 2005 6:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CPU performance maxing out in Designer
- Replies: 5
- Views: 1326
- Fri Apr 29, 2005 9:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: account hash files usage
- Replies: 8
- Views: 2142
- Thu Apr 28, 2005 3:57 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Command Stage
- Replies: 6
- Views: 1217