DSXchange

rmabbitt... There's no doubt ... Query building is your worst nightmare. I am not aware of any shared library of Queries, but it's a great idea. I would suggest you start by finding a Query which is close to your needs, cloning it and making minor adjustments. Templates are more easily understood - ...

Arattra ... Ascential now offers the MetaArchitect tool which is the engine they use to develop and enhance the existing set of MetaBrokers. This tool is not free and it is not trivial. There are folks here on the forum who have used it to create their own ProfileStage MetaBroker since Ascential has...

Sreenivasulu ...

If you go to the c:\Program Files\Ascential\MetaStage\QualityStage7 MetaBroker folder you will find a .pdf containing installation instructions.

... tom

Dear Mr. (Ms?) DataStage: Can you elaborate any and how these metabrokers and MetaStage can work with both the physical schemas and the logical schemas (where you might find a little more of the business logic meta data)? I have not had the time to explore the results of a Logical model import. Typi...

Leslie ...

That's Horseshoes, Handgrenades and Heavy Breathing.

... tom

We found that NOTFOUND was solid when used in a DS390 job to test results of a DB2 referential read ... but returned variable results when used in a Server job to test Hash success.

... tom

CMuller ... We have a DB2 meta data repository. We created a DB2 Staging Area (to merge the meta data from several MetaStage repositories). Then, for each MetaStage repository, I issue SendtoDB twice, once for each MetaBroker (CDSA & DS7). This creates some 550+ tables. We then evaluated which t...

1) A primary source of Business meta data is via import from your modeling tool. Column and Table descriptions will participate in the import and export to DataStage. The ERwin MetaBroker now also supports the ERwin UDP (User Defined Property) option which enables free-form meta data entries such as...

hkotze ...

I would suggest you contact Ascential requesting an EVAL copy of MetaArchitect. However ... you will not be able to do this "urgently". MetaArchitect is not a trivial tool ... I suspect it will do what you want, but you must learn the tool first.

... tom

Kiran - Craig - Ray ...

Many thanks for your input. Damn, now I've got 3 choices ... :D

... tom

Hi All ... I've been trying to fit this requirement into a hash file without success. I know I can solve this with a temporary table, but I'd rather do a hash: I will create a series of rows out of my Transform. These rows will contain a column named smallest_nbr which is a value achieved by subtrac...

Process meta data is typically deleted, not archived. If you REALLY want an archive, you will need to consider: 1) Creating a script which launches RunImporter. 2) Since the import here is a destructive one, have your script copy the XML file to a timestamped landing area as the first step. This is ...

Evan ... You've just opened the door to a VERY large room. The reporting tools which arrive with MetaStage are very comprehensive. If you've imported it, you can report on it. So how? RTFM, or Read the Friendly Manual. There are no shortcuts here, you've got to get a full comfort level with Online D...

Hi Folks ...

I've read the posts regarding the hookup between the DB2 PlugIn and DB2 Connect, but at what point is DB2 Connect justified?

thanks ...

... tom

Preethi ...

I would first check with your DBA to make sure you have appropriate read/write/select access to your repository.

... tom