Search found 53125 matches

by ray.wurlod
Fri Nov 21, 2008 10:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: fetching first few records
Replies: 9
Views: 1870

The second person personal pronoun in its nominative case is spelled "you" in English, not "u". Please maintain a professional standard of written English at DSXchange, which is not a cell phone. Further, U is the name of one of our posters. In that context your reply is unhelpful, because U did not...
by ray.wurlod
Fri Nov 21, 2008 9:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Identify rows resulting in Reference lookup generated X rows
Replies: 3
Views: 1215

Welcome aboard.

Query the reference table.

Code: Select all

SELECT key,COUNT(*) FROM tablename GROUP BY key HAVING COUNT(*) > 1;
by ray.wurlod
Fri Nov 21, 2008 9:46 am
Forum: General
Topic: Copy column and derivation in Transformer stage to document
Replies: 6
Views: 5292

No - it was introduced in 7.5. In 7.1 you can generate the bitmap and the XML report from the command line, but not from the GUI.
by ray.wurlod
Fri Nov 21, 2008 3:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RT_ERRORS with a twist.
Replies: 6
Views: 1648

You need to be really careful with MFILES. It can be no greater than (NOFILES - 8), where NOFILES is the kernel parameter that sets a limit on the number of file units one process can have open. The name may be (will be) different on different UNIXes.
by ray.wurlod
Fri Nov 21, 2008 3:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parameterizing table structures.
Replies: 15
Views: 4652

Ten separate jobs, each using correct metadata, would be my preferred approach - easier to maintain when things change.
by ray.wurlod
Fri Nov 21, 2008 3:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while using Schema file for the metadata
Replies: 1
Views: 898

One of the reasons you (and we) can not diagnose this error is that you have no idea what's generating it because you have operator combination occurring.
by ray.wurlod
Fri Nov 21, 2008 3:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup warnings in TPT
Replies: 5
Views: 2483

You either need field A on the output of the Modify stage or you need to remove the KEEP specification for field A. This may be an implied KEEP specification if you have a DROP specification for other fields; in this case add field A to the DROP specification.
by ray.wurlod
Thu Nov 20, 2008 7:50 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Help - Transform readonly in V8 and now cant compile job
Replies: 6
Views: 2489

Do the export of Transforms again, but this time choose the "include read-only objects" on the Options tab of the export dialog. Otherwise read-only objects are not incorporated into the export file.
by ray.wurlod
Thu Nov 20, 2008 7:48 pm
Forum: General
Topic: MQ Series Invoke DataStage Job.
Replies: 20
Views: 7967

Yes I could, but so can you. Search (here and IBM) for Information Services Director, SOA and - for older versions - RTI.
by ray.wurlod
Thu Nov 20, 2008 7:46 pm
Forum:
Topic: Information Analyzer and Business Glossary in Version 8
Replies: 29
Views: 15442

That's the process called importing metadata. You can do it through DataStage, through Information Analyzer, through Metadata Workbench, and so on. It all ends up in the same place, the common metadata repository. All of the Information Server products access it via metadata delivery services. But y...
by ray.wurlod
Thu Nov 20, 2008 6:26 pm
Forum:
Topic: Information Analyzer and Business Glossary in Version 8
Replies: 29
Views: 15442

Re: Imorting metadata

Since we already have metadata it doesn't require any profiling. That statement is still 100% wrong. See my previous post. Table definitions that you have imported are stored in the common metadata repository (XMETA) which all of the Information Server products can access. This means that the produ...
by ray.wurlod
Thu Nov 20, 2008 6:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Execute Command Activity error
Replies: 4
Views: 1287

Then please mark this thread as Resolved using the green button at the top of the page.
by ray.wurlod
Thu Nov 20, 2008 6:22 pm
Forum:
Topic: Information Analyzer and Business Glossary in Version 8
Replies: 29
Views: 15442

Re: Imorting metadata

Since we already have metadata it doesn't require any profiling. That statement is just so, so wrong!!! What proportion of each column is populated? Are there any out-of-domain values? Is there over-use of default values? Are you totally confident that all the data types used are appropriate? Or th...
by ray.wurlod
Thu Nov 20, 2008 5:43 pm
Forum: IBM QualityStage
Topic: MatchDesigner usage with Blocking and Matching Columns
Replies: 5
Views: 2529

Good catch - I got caught up on the thresholds.
by ray.wurlod
Thu Nov 20, 2008 5:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with Null Field length in Sequence file
Replies: 2
Views: 780

This seems to be the same post that you put in the General forum.