Search found 53125 matches

by ray.wurlod
Tue Jan 03, 2006 3:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Specifying null value attributes through column properties?
Replies: 5
Views: 5149

No. Sounds like inconsistent handling of nullability. The problem is between the keyboard and the chair.
by ray.wurlod
Tue Jan 03, 2006 3:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to convert string to int in modifystage
Replies: 4
Views: 2840

I would have thought some of the simpler functions, such as int16_from_string or int32_from_string, or uint32_from_string, would have been more appropriate.
by ray.wurlod
Tue Jan 03, 2006 3:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compilation Error in Parallel Job (in Transformer stage)
Replies: 14
Views: 6756

That is not the same problem. Windows is very different. Please open a new thread.
by ray.wurlod
Tue Jan 03, 2006 3:40 pm
Forum:
Topic: Business Object repository
Replies: 8
Views: 2864

Develop in what way? They've certainly stated an intent to keep them up to date with technology change. Is that what you mean?

If you have ideas about how products can be enhanced there are lots of ways you can make them known, including the Wish List forum on this site.
by ray.wurlod
Mon Jan 02, 2006 11:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Protected project
Replies: 1
Views: 1314

You can create the job in an unprotected project, then move the completed job into the protected project.

You can unprotect the project - these are intended to be used for production environments, where Designer should never tread (well, maybe to inspect, but nothing more).
by ray.wurlod
Mon Jan 02, 2006 11:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Connection from client to Server
Replies: 6
Views: 1632

I have been engaged in training some folks who use a Citrix connection from Bangalore (India) to the USA. Its performance is quite acceptable.
by ray.wurlod
Mon Jan 02, 2006 11:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: slowly changing dimensions
Replies: 3
Views: 1399

Version 8 of DataStage EE has a Slowly Changing Dimension stage. You could use that. Unfortunately, version 8 has not yet been released. They showed it at the show in Las Vegas in November 2005, though, so some folks have been fortunate enough to see it. It's now in beta, expecting a Q2/2006 release.
by ray.wurlod
Mon Jan 02, 2006 11:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer Error
Replies: 6
Views: 2180

Nearly everyone has problems with the Transformer stage on DataStage EE on Windows. Are you using Windows XP? What C++ compiler did you install?
by ray.wurlod
Mon Jan 02, 2006 11:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Stage PX
Replies: 3
Views: 1011

The Sort stage gives you greater control over resource allocation, such as how much memory is allocated to the sorting process (per processing node). The maxima for these are larger in the Sort stage, also.
by ray.wurlod
Mon Jan 02, 2006 7:53 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ETL auditing
Replies: 9
Views: 2918

Short of carrying source system, source file/table and source key/line information through to target, I can't think of any way conveniently to provide the source detail that Carol's end users appear to want.
by ray.wurlod
Mon Jan 02, 2006 7:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ETL auditing
Replies: 9
Views: 2918

Lineage analysis can prove that the data have come from the correct source and been subject to the correct processing on their way through.
by ray.wurlod
Mon Jan 02, 2006 7:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 access
Replies: 5
Views: 1303

Welcome aboard! :D 1) Is it mandatory to specify table definition in the DB2_UDB_API job in order to retrieve data from a DB2 table? Yes. 2) Is there any workaround to avoid specifying table definition such that a d.s. job can be designed in a generic way to retrieve data from multiple tables on DB2...
by ray.wurlod
Mon Jan 02, 2006 4:01 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ETL auditing
Replies: 9
Views: 2918

Think MetaStage. It captures process metadata automatically and comes (these days) with some canned reports. It can also do Lineage and Where Used analyses across the entire enterprise.
by ray.wurlod
Mon Jan 02, 2006 3:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: running PX on a Windows Platform
Replies: 6
Views: 1489

That's definitely minimum! I'd recommend not less than 1GB RAM, more is better. More than one CPU is better also. Multiple disk drives (not drive letters) is also good.
I would not use Windows for production DataStage EE.