Search found 53125 matches

by ray.wurlod
Fri Mar 23, 2012 3:25 pm
Forum: General
Topic: DataStage, Universe & TCL
Replies: 4
Views: 2129

Metadata Workbench is the principal reporting tool for metadata.
You can generate reports from most of the products in the Information Server suite, and access these reports from the Reporting console (Web console for InfoSphere Information Server, Reporting tab).
by ray.wurlod
Fri Mar 23, 2012 3:20 pm
Forum: General
Topic: I passed the 000-421 DataStage v8.5 certification!
Replies: 18
Views: 45158

Course code conventions have changed only recently from DX to KM. For the same course (for example Advanced DataStage v8.5) the materials have not changed. So don't worry about the code. The first of the v8.7 classes are beginning to appear; I'm soon to present the one for Business Glossary.
by ray.wurlod
Fri Mar 23, 2012 3:17 pm
Forum: General
Topic: Parameter Setting in Sequence showing Error
Replies: 11
Views: 4469

This error might occur, of course, when you're trying to use the Insert Parameter tool, if the parameter does not exist (or no longer exists) in the controlled job.
by ray.wurlod
Fri Mar 23, 2012 12:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Combine columns from Dataset and tables.
Replies: 7
Views: 2249

So what is the rule? First row with first row? Is there perhaps only one row in each source?

Without knowing the rule no-one will be able to help you.

Once the rule is known, the answer will probably involve generating an artificial key on each stream of data.
by ray.wurlod
Thu Mar 22, 2012 10:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Grouping
Replies: 7
Views: 2846

We don't know either. Waiting for Ravi.K to do the needful.
by ray.wurlod
Thu Mar 22, 2012 10:31 pm
Forum: General
Topic: what is new features of datastage 8.5
Replies: 7
Views: 6784

The topic's been answered. Let the spiral spiral...
by ray.wurlod
Thu Mar 22, 2012 8:24 pm
Forum: General
Topic: what is new features of datastage 8.5
Replies: 7
Views: 6784

No.

The difference between 8.5 and 8.1 is -0.4.
by ray.wurlod
Thu Mar 22, 2012 8:21 pm
Forum: General
Topic: using same client to connect to Windows and Linux engine
Replies: 7
Views: 1772

With everything at the same version you shouldn't need MCM.
by ray.wurlod
Thu Mar 22, 2012 5:10 pm
Forum: General
Topic: using same client to connect to Windows and Linux engine
Replies: 7
Views: 1772

It should be possible. Are both servers managed by the same domain? If not you need to specify the correct domain in the login dialog.

Unfortunately error code 81001 is "connection closed for an unspecified reason" which is not all that helpful.
by ray.wurlod
Thu Mar 22, 2012 3:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: OSH_PRINT_SCHEMAS: Trying to understand the output
Replies: 3
Views: 3318

The "all columns" pieces are there to support runtime column propagation (RCP). They are reported whether or not RCP is enabled.
by ray.wurlod
Thu Mar 22, 2012 3:17 pm
Forum:
Topic: Physical Data Model
Replies: 10
Views: 4652

This is a government site. Everything is locked down so-o-o tight. There's no Access on the server - just a bare bones O/S before we installed Information Server. I'd be tempted to push back and tell them they don't have a physical data model, and perhaps to insist that they reverse engineer one as ...
by ray.wurlod
Thu Mar 22, 2012 3:13 pm
Forum: IBM QualityStage
Topic: Tokenization of more than one word
Replies: 1
Views: 2006

Surround the string with double quotes.
by ray.wurlod
Thu Mar 22, 2012 3:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Surrogate key limit
Replies: 2
Views: 1413

The largest uint64 (unsigned BigInt) value is 18,446,744,073,709,551,615 which contains 20 digits.

Therefore your expression should allow for up to 20 characters.

Code: Select all

Right(Str("0",20) : InLink.SKey, 20)
by ray.wurlod
Thu Mar 22, 2012 3:06 pm
Forum: General
Topic: what is new features of datastage 8.5
Replies: 7
Views: 6784

Difference between 8.1 and 8.5 is 0.4 (simple arithmetic).

Check the IBM Information Center for what's new in version 8.5.

Why not also check the IBM Information Center to find out what's new in version 8.7, which mandyli has summarized?
by ray.wurlod
Thu Mar 22, 2012 3:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to add header column c:Name:string
Replies: 9
Views: 2476

DataStage won't accept the colon characters. Perhaps you could use underscores and change them subsequently.