DSXchange

I find it inconvenient though when in order to switch projects I have to go through Director and as a consequence view only one project at a time. This functionality is unchanged between 7.x and 8.x. Designer could never switch between projects. Director always could. In either tool you can only vi...

What I provided was, pretty much, the detailed design. Standardize the data, create the match specification (only you can decide the appropriate blocking columns and matching commands for each pass), and calculate match frequencies before performing the matching step.

Your format string specifies delimiters that your data lacks. Try something like Note the leading space in the time component corresponding to the space in the format string.

And here it is very clear that Microsoft SQL Server 2008 R2 Enterprise Edition x86-64 is supported.

IBM's comment that you cited was for version 8.1, not version 8.7.

SURA wrote:The latest Datastage 8.7 Version is not compatible with SQL Server 2008 R2.

Interesting. I've installed Information Server version 8.7 using Microsoft SQL Server 2008 R2 as the metadata repository.

That does not suggest "incompatibility" to me!

Rank is a display function, not an ETL function.

The main one is to make sure that your Otherwise/Log output link is executed last, even if you create more output links after you create that one.

I guess the health care industry might work more with masked data and generated test data than many other industries, at least in development environments.

So is Paul.

What would you expect to be different as far as ETL processes are concerned? They are specified by business analysis and the like and implemented by you.

There is a different underlying model, but that ought not to be the concern of an ETL developer.

Developers don't really need to know about these tables. They seem to be falling into disuse in any case.

karthi_gana wrote:Am I correct?

Not entirely. If snowflakes exist these must be loaded even before dimensions, from the outside in.

This was incorrect. Time is not made up of year, month and day. Time is seconds since midnight. At most 86399.999999.

Transforms are pre-stored single expressions. (Routines can consist of many lines.) Originally server Routines did not have a mechanism for passing arguments to them and had to be invoked via a Transform. These Routines carry a version number of 1.0. Nowadays server Routines carry a version number o...

Only alphabetic class-designator characters appear in classification tables. The non-alphabetic class-designators are built-in and not specific to any particular rule set.