Search found 86 matches
- Tue Aug 30, 2011 12:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: InfoSphere DataStage Balanced Optimization
- Replies: 1
- Views: 5073
InfoSphere DataStage Balanced Optimization
Has anybody used InfoSphere DataStage Balanced Optimization? If yes, how well is it implemented? i.e. is it buggy? Is it as good as Informatica's push down optimization? Based on what I've read in IBM's docs it seems like a quick and dirty implementation that is not integrated very well in to the to...
- Sat Jan 02, 2010 6:16 pm
- Forum: General
- Topic: DataStage vs. Ab Initio
- Replies: 22
- Views: 28898
development time
I disagree. Development time in Ab Initio is faster than in DataStage for any job that is moderate or more complex. Basic jobs may be faster in DataStage. 1) making reusable jobs in Ab Initio is easy. Reusable jobs in datastage are impossible if the job is is not basic. This makes development longer...
- Sat Dec 26, 2009 4:35 pm
- Forum: General
- Topic: DataStage vs. Ab Initio
- Replies: 22
- Views: 28898
I'm going to get some official specs on the hardware after the new year... I think the abinitio hardware is better. In particular the I/O speed. Re: join one cool thing about joins in ab initio is that you can overwrite the default comparison methods. So you can program how the comparison between tw...
- Wed Dec 23, 2009 10:50 am
- Forum: General
- Topic: DataStage vs. Ab Initio
- Replies: 22
- Views: 28898
I know I should use the join stage in a real life scenario, but I'm trying to see which tool can handle large lookups better in a test scenario. Switching from 4 nodes to 16 node helped a bit, but not even close to 2x. Here are some more results: # records: 1 million 1 node (\w disk pool) 00:31 2 no...
- Tue Dec 22, 2009 4:12 pm
- Forum: General
- Topic: DataStage vs. Ab Initio
- Replies: 22
- Views: 28898
Here is the config file
{ node "node0" { fastname "localhost" pools "" resource disk "mask/partn/00" {pools ""} resource disk "mask/partn/01" {pools ""} resource disk "mask/partn/02" {pools ""} resource disk "mask/partn/03" ...
- Tue Dec 22, 2009 4:05 pm
- Forum: General
- Topic: DataStage vs. Ab Initio
- Replies: 22
- Views: 28898
DataStage vs. Ab Initio
Everybody has been telling me for years that Ab Initio is the best ETL tool. I finally got a chance to use it and it is sweet! From a developers point of view it is much more versatile, intuitive, and stable. You have to do more scripting, but it's simple. I ran a couple of tests to see how it perfo...
- Tue Jun 30, 2009 12:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: RCP does not work with the Stored Procedure Stage
- Replies: 5
- Views: 2907
- Fri Jun 26, 2009 8:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: RCP does not work with the Stored Procedure Stage
- Replies: 5
- Views: 2907
- Thu Jun 25, 2009 11:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: RCP does not work with the Stored Procedure Stage
- Replies: 5
- Views: 2907
RCP does not work with the Stored Procedure Stage
Hi, Has anybody been able to get RCP working with the stored procedure stage? It doesn't have an RCP checkbox like every other stage, and when I tried to run the job then all the columns that were expected to move through RCP were dropped. There is no mention of RCP in the Connectivity Guide for Sto...
- Fri Jun 19, 2009 7:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SCD stage not working in 8.1 for windows
- Replies: 6
- Views: 4003
- Wed Apr 29, 2009 1:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: system cached hash files for realtime EDW solution
- Replies: 1
- Views: 1735
system cached hash files for realtime EDW solution
Can anybody comment on how effective system cached hash files are in production? Are they reliable for large lookups (10 milion records)? We're thinking of using them for a realtime EDW solution instead of sparse lookups.
Any idea why they are not supported in parallel jobs?
Any idea why they are not supported in parallel jobs?
- Fri Apr 24, 2009 8:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SCD stage
- Replies: 10
- Views: 5395
- Wed Apr 22, 2009 4:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SCD stage not working in 8.1 for windows
- Replies: 6
- Views: 4003
SCD stage not working in 8.1 for windows
The SCD stage works in 8.01, but not in 8.1. I get this error message: scd_SCD2: Error when checking operator: Caught unknown exception during wrapDescribeOperator(). scd_SCD2: Error when checking operator: setInputInterfaceSchema() was not called by describeOperator() for input: 1. Error when check...
- Mon Apr 20, 2009 5:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SCD stage
- Replies: 10
- Views: 5395
- Fri Apr 17, 2009 7:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SCD stage
- Replies: 10
- Views: 5395