DSXchange

Anyone had experience with Cognos version 8 and MetaStage? Any "tales from the trenches" you'd like to share?

The MetaBrokers are only documented for use with Cognos up to version 7.5 and version 8 is radically different. I am experiencing vast difficulty moving metadata between the two.

mohanraj wrote:Can anyone tell me that how can I abort the job.

The ol' power switch is singularly effective!

Isn't Plz a town in the Balkans somewhere?

Do a search of DataStage help looking for the Link Variables topic. This should be as clear as you're going to get.

Probably not.

"API stage" (sequential execution) is a term used to differentiate from "Enterprise stage" (parallel execution, at least in theory).

How do you manage writing to a Sequential File stage as target in parallel mode? Is a Collector present on its input link?

Is anyone aware of - by which I guess I mean has anybody written - a MetaBroker for PowerDesigner version 12?

The MetaBroker that ships with MetaStage 7.5 supports only to PowerDesigner version 9.5.

What's wrong with something like
Isn't that readable?

Well, the original request included end time. That's precisely when the stats are captured for MetaStage. And automatically loaded into the MetaStage Directory, to be queried at leisure. Immediately is OK; they're available as soon as they've been imported.

Whatever is right for you, Ross. It's impossible to advise without having some knowledge of the actual business. The Hashed File stage does not care, but you might (will) need to be careful with the use of job parameters across different environments (development, test and production).

Depending on the stage type you can also get LASTERR as well as DBMSCODE (these are output link variables from the link attempting to put the row into the target database). Capture these onto a separate output link from the immediately-preceding Transformer stage.

Multi-column keys in hashed files have @TM as a separator character. Your key expression therefore must be of the form

The number of partitions created in Data Sets EQUALS the number of logical nodes in the configuration file, unless the operator that creates the Data Set is constrained to operate in a node pool containing fewer nodes. However, the number of resource disks used for the data files of a persistent Dat...

No, the requirement is for a vertical pivot. The Pivot stage only does horizontal pivots. I can not see any logic in the example for determining which rows accumulate into columns. Did you give erroneous values for the P column? Search the forum for "Vertical Pivot" to find some techniques. Make sur...

So what's different between the two environments?

"Nothing" is clearly not the correct answer.