DSXchange

Fabio ... The DataStage project you are trying to import is too large. Ascential recommends a JobDesign limit of 300, and these can be considered small to average size. As some of the commentators above have suggested, you might try filtering and accomplishing the import in two passes. I don't remem...

If you are not seeing the "Operate in MetaStage Proxy Mode" checkbox in the DataStage Administrator, you can manually enable the proxy mode by editing the DSPARAMS file in UVHOME/PROJECTS/<Project Name>/DSParams. At the very bottom of the file under the [ Project ] section: MetaStageModeEn...

Hi Guys ...

I am constructing a little server job which will collect data and not write until a specific row arrives. It's typical control break logic.
Question: when I hit EOF will DataStage write out the unwritten stuff held in Stage Variables (which are mapped to the output link)?

... tom

Hi Dave ...

Sounds like you will have to blow away your latest import. Go to Maintenance => Directory Versions. The top-most row reflects the most recent import and it probably has an asterisk meaning locked. Delete this and do a new import.

... tom

I can use Count to tell me whether or not a desired value lives in a string, but how can I get the starting location of that value so I can extract it?

... tks in advance

... tom

Sunil ... What I suspect is happening is that you've chosen RELATION table as your target for your custom MetaBroker ... and you've landed your data there. However, when you initiate the Publish to Browser function, there are EXISTING mappings heading for that same table. So you land your data and t...

The DB2 column description field does not map to the DataStage column description field. I would suspect that DB2 is not honoring your descriptions. If you use MetaStage to move from ERwin to DataStage the descriptions will survive. I would also bet that if you just use the DataStage ERwin MetaBrok...

Then there is the even more unreliable field description field. If MetaStage is used to import the table and column descriptions from ERwin and export them to the DataStage repository, they will arrive intact. And then they will participate in the Publish to Browser as "Busines Name", etc...

This is probably quite simple ... I want to create a little hash file with some literal values. And I can build these values in the transformer stage, so I have a 2 stage job: xfm => hsh. But the compiler doesn't like it, telling me there is "no primary input stage". Is there a short-cut h...

MetaArchitect was originally called "MetaArchitect Lite" ... no one seems to understand why the "lite" was ever added to the name, but it has been removed. The first consideration when considering a custom MetaBroker is where to land this new data. The MetaStage meta model is a f...

I need to find whether the metadata is loaded from a table definition into a particular stage or it was typed manually. Ray is correct ... if Good Practice was followed, i.e., the meta data was loaded from a table definition or if it was typed manually AND a SAVE was issued, it will be available in...

K.P. When you build mappings with DataStage, the table definitions are stored in the DataStage repository. When you want to collect meta data, you will be importing these objects (Job Designs, Table Definitions, etc.) from DataStage into the MetaStage repository which is object oriented. Runtime or ...

Yeah ... this is kinda common. Could be database is down, you might be using wrong schema name, wrong user name, wrong password.

... tom

First of all consider that MS is ideally located on the DS server to efficiently capture Operational meta data. Also consider that MS is essentially a Project (read DataStage Project) repository and comes with size limitations. If you anticipate collecting meta data from many DS projects, you will n...

What arrives with MetaStage, i.e., MSJavx86.exe is an upgrade to JVM. You must already have JVM on your machine for this upgrade to be effective. If you don't have JVM, during the upgrade it will say something to the effect that "... this is an upgrade to the JVM environment" ... then goes...