DSXchange

I'm trying to understand the difference between the 'SQL Server Build - No Constraints.sql' and 'SQL Server Build Constraints.sql' scripts and their relation to the main build script 'SQL Server Build.sql' Is it as simple as Build.sql is a combination of both, and No Constraints.sql is what you woul...

This won't apply to Srini's problem of rules in java code, but with that type of question in general I'm intrigued with what Razza Dimension Server can do for an organization. There may be some intregration with Ascential products in the future and there is also a Master Data Management forum on thi...

The introduction of a rules based engine for transformation removes the T from the ETL formula. In my opinion, the T is the strength of DataStage. I suggest that your company probably bought the wrong tool if all they need DataStage to handle is the E and the L. The amount of business logic without...

You might try hacking into the underlying database and changing the data type from Text (50) to something larger. I don't know if there's any code within Audit Stage that checks a hard coded limit of 50, however. Darn you Ray! Don't you hate it when work seeps into the rest of your life? I just had...

what's the fun of reusing predesigned components for slowly changing dimensions? They are taking all of our fun away. I wonder how well it works though, SCD theory never changes, but everyone's real life situation always seems to vary....curious if it is versatile enough to handle anyone's SCD chall...

Has anyone found a work around for the greater than 50 characters element not allowed for the LO analysis? I could create an exception table & modify the length and repeat the process. I was just wondering if anyone else had any ideas on this. I'm about 98% sure (didn't check specifically) that...

kduke wrote:Byron

Don't hate the player besides you are really racking up the points.

Kim, it's playa not player.

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 a...

Arattra, You mention {Business Rules, Business Terms, Business Definition and other Business Metadata Attributes} . Are you also finding difficulty in ownership of these items in terms of business-only side persons, IT managers, and the IT developers? Same with a difficulty in how to share and dispe...

The best place (imho) to record business metadata is in the long description fields within DataStage jobs, routines, data elements and transforms (and, possibly, table definitions, for business metadata such as ownership, responsibility for authorising changes to table design, and so on). The long ...

a Mobile Director progam has been created so we can work from airports, hotels, lunch breaks, between nines on the golf course. It will require Pocket PC 2000 OS, Pocket PC 2002 OS, or Windows Mobile for Pocket PC 2003 or higher; Microsoft .NET Compact Framework 1.0 SP2; and RTI 7.5

a few years back I undertook the task of searching for an UNIX driver for MS Access. I did find one from a third-party provider after very long and painful searching on the Internet. Wasn't from ASCL, Microsoft, or another name you'd recognize. A workaround to consider is export to a comma separated...

kduke wrote:Only version 7 needs all that. The other releases keep a lot less information.

Thanks Kim

After cleanup up and reinstalling, there are 3525 entires with the string "VMDataStage" and 1577 with the string "vmds". That's over 5000 entries there's definitely more.

Has anyone noticed just how many entries DS makes into the Windows Registry (i'm looking at a computer with both the server and client installed)? I've found over 600 entries counting all types of registry entries. I've been having trouble switching releases and though maybe that was part of the pro...

Just to clarify since the original question had both styles in it and to add to Kim's explaination, syntactially you can use either the pre-definined variables such as @FM or a fucntion like char(254) in your DataStage code syntax. Both work fine, but as a best practices method I think the system va...