DSXchange

Noting that you are using version 8.x, the approximate equivalent of the tool that Ernie mentioned is Metadata Workbench. Do you have Metadata Workbench in your Information Server installation? If so, you can request a data lineage report. If this report turns out to be incomplete, then you may need...

Allow me to re-parse your stated requirement and then offer my "solution".

(If column = 'true' Or column = 'false') Then transfer row to output.

Solution: transfer all rows to output.

Tried both the Trusted Root Certification Authorities and the Trusted Third Party Root Certification Authorities stores. Neither worked. Even when installed by someone with local Administrator access.

Here is a sketch of a design to establish contiguous groups. Once those have been established it is a simple matter downstream to perform checks for records in which dates overlap. For each group we will determine Min(start_date) and Max(end_date). Grouping is based on ID, and can be detected using ...

Then it would seem that the first thing you need to get right is your partitioning algorithms. Any time you need to compare values, you need to ensure that the values to be compared are on the same partition as each other.

Does it work properly if you run on a single node? If yes, then there is something wrong with your choice of partitioning algorithm. Please confirm that you want to capture sets of rows in which there are overlapping date ranges. There is a technique for this, but I want to be sure I'm answering the...

DataStage notes that "#" is a reserved character. It can (should) be replaced with the special value __035__ (documented here).

You could also have performed the data type conversion within a Transformer stage.

Both of these statements cannot be true.

splayer wrote:The ORA error is what I saw when I took the SQL to Oracle. It was not there in the Director log. Sorry about the confusion.

splayer wrote:The job has been running fine for years. In the last run, it suddenly started giving ora-01438.

An airship called the Hindenburg, a ship called the Titanic, an editor called vi...

Yes there is, and yes you do. The very first property on the link (Usage grid) in a Connector stage type is Generate SQL, and it takes Yes or No as its value.

If you set it to Yes you must provide the Table Name (of course).
If you set it to No you must provide an SQL statement.

Any decimal number larger than 99.99 will cause this overflow condition. If, for example, it's a percentage, it may be that 100.00 has come through as a value. DataStage server jobs don't care (as they treat everything as string internally), but Oracle will reject a row containing such a value. Add ...

Rocket U2 UniVerse and DataStage engine did indeed go their own ways (although many similarities remain, the development trajectories have been quite different) when IBM took over UniVerse from Informix in 2000/2001. That the version numbers are currently both 11 is purely coincidental.

rameshrr3 wrote:@Chullet : (Part 1) is on the same shelf where windows 9 and datastage 10 are

DataStage 10 does exist - it's the engine underneath IBM's Master Data Management server. It was never released as an independent product, however, for reasons that are internal to IBM Marketing.

I believe the rules would first be defined in the IS Console rich client tool and published for use by data rules stage correct ? Data Rule Definitions can be created in, and published from, the Data Rules stage, as well as using the IA console. What 'scripting' language do data rules expressions u...