Search found 4992 matches
- Thu Apr 02, 2009 10:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: confusion and request for help setup Windows UNIX datastage
- Replies: 9
- Views: 7736
Just to be clear - you purchase either a Windoze or a Unix version of DataStage. The Clients are always on Windoze, the Server is platform selectable. Everything resides on the Server side. If you write your jobs to be transportable, they can run in either Server environment. Most companies have a s...
- Thu Apr 02, 2009 10:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job do not progress after certain percent...
- Replies: 20
- Views: 11638
Is this a new installation? Is this the only table you're having loading issues? Can you load the data into a another table with the same structure? There are too many variables. It sounds like you have some sort of issue writing to this table. Start with a simple design that extracts your source da...
- Wed Apr 01, 2009 12:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Different ways to recover scd type 2 data load failure
- Replies: 4
- Views: 1765
That would have required you to build an ETL framework that captures inserts and updates and the before images of the rows updated. You would delete your inserts and update your updates with the before-image. Otherwise, you're in to using database table recovery procedures such as logging to rollbac...
- Wed Apr 01, 2009 12:38 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Universe Query -
- Replies: 23
- Views: 7316
Huh? 200 million network + database queries is better than a hashed equi-join lookup with preloaded/cached data? Unless you think the PX Join is doing network lookups (sparse lookup) then I don't know what you're thinking. If Server is your only option, the best choice is to find a way to use a hash...
- Wed Apr 01, 2009 11:21 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Universe Query -
- Replies: 23
- Views: 7316
To answer the original post, why would you even need to see values that were passed to the key expression when you already have them available? As for the ultimate question about ranged lookups against hashed files for high volumes - forget about using the UV/ODBC interface as it's better than a dat...
- Wed Apr 01, 2009 10:44 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage-Unix I/O transfer problem ?
- Replies: 16
- Views: 6684
- Wed Apr 01, 2009 9:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage-Unix I/O transfer problem ?
- Replies: 16
- Views: 6684
The poster has stated there's a lag between the script and the startup of the job, and then switches and states processing time is increased. Is this two issues being stated or one? If the job has a delay between the script executing the dsjob command and the job actually starting - this is probably...
- Thu Mar 26, 2009 10:22 am
- Forum: General
- Topic: Global KeyMgtGetNextValueConcurrent
- Replies: 5
- Views: 2052
- Wed Mar 18, 2009 11:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Getting Parameter value into routine
- Replies: 2
- Views: 1575
If you're calling a before/after routine and you want the job parameters passed into the routine, you are given InputArg as the only argument to hold your parameters. One common way is to space separate the argument values (supply them as the parameters). The value of InputArg will be the space sepa...
- Wed Mar 18, 2009 9:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to get Fiscal year from the date "2008-04"
- Replies: 10
- Views: 4666
- Tue Mar 17, 2009 12:52 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: bitmap indexes performance
- Replies: 8
- Views: 2895
Oracle bitmap indexes are a well known issue with ETL. You need to drop/disable, load, and rebuild these indexes during your ETL cycle. You need to read up on bitmap indexes to understand why. The short answer is that a bitmap can have only a few entries that span the entire table. Inserting/updatin...
- Tue Mar 17, 2009 12:07 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Is Performance is based on Logic or volume of data?
- Replies: 2
- Views: 1780
- Tue Mar 17, 2009 11:11 am
- Forum: General
- Topic: Reading the correct file
- Replies: 7
- Views: 3212
- Mon Aug 04, 2008 12:46 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Increasing rows per transaction USING ODBC
- Replies: 5
- Views: 3648
- Thu Jul 17, 2008 10:37 am
- Forum: General
- Topic: Shell script to start a job using dsjob
- Replies: 13
- Views: 41293