DSXchange

Welcome aboard. :D

What you are seeking to do is called a "horizontal pivot" and is performed by the Pivot stage. Read its manual (pivot.pdf) for a good description of how to use it.

Thanks for suggestions. Will check PATH. The Test button on the ODBC configuration tool reports that connection successful. It's version 7.5.1 of ProfileStage; the setup utiility includes 10g as an option in the drop-down list for Oracle PSDB, and Windows 2003 is a supported platform. The same error...

Your generator is running in sequential mode, only on partition 0. Its CPU figure is 0.11. The Peek stage, however, runs in parallel mode, and there is therefore a pair of entries for that stage from each partition (2(b) and 3(b) in your listing), each of which shows 0.11 for CPU seconds. This job o...

Client: Windows 2003 Server sp1 Server: Windows 2003 Server sp1, Oracle 10gR1 Oracle properly set up, with database STATWH configured and accessible via SQL*PLUS both from client and server machines. ProfileStage client, message switch and analysis server already installed on Client machine. I now a...

ray, I would appreciate it very much if you could answer the fastname question as well. That WAS the answer to the fastname question. There are two partitions (nodes) on which op1 executed. Consider lemond.torrent.com. They can't be the node name from the configuration file, because node names must...

Welcome aboard. :D

You are correct to assert that the interface is different, remember that the parallel version must take into account the need to split the rows into multiple parallel streams.

Is there anything in particular about which you want to ask concerning the parallel CFF stage?

thomsonp, thank you very much for you response. I have a few more questions to you and ray. a)Line 1: Does that mean that the entire job has 1 data set stage? b)Line 2: ds0: It probably is referring to the first dataset, right? {op0[1p] (sequential generator) : First dataset operates on the second ...

splayer wrote:How do you know that the two processes have the same fastname? Shouldn't there be a fastname keyword first?

16) lemond.torrent.com[op1,p0]
17) lemond.torrent.com[op1,p1]

This is operator #1 on partitions #0 and #1. All counting begins from zero (since it's C underneath).

The Sequential File stage may use a filter command. You enable this via a check box. The output of that filter command is then read by the stage. If your filter command tests for the size of the file, using test or wc command, then its result (zero or non-zero) can be used to generate the row. After...

It's certainly not a valid number - it has two "-" characters in it for a start. What is the data type of the target column? Are you using generated or user-defined SQL?

You've got a Sequential File stage downstream of the Join stage. For the Join stage you have had to partition the data based on key value. The message is essentially telling you that the Sequential File stage does not operate in parallel, so cannot preserve the partitioning specified for the Join st...

You must make sure that data from target and source are identically partitioned so that all valid comparisons are correctly made. Loading dimesion (parent) tables first if the natural key does not already exist, insert a new row. If the natural key does exist in the target check for differences in r...

c) The three processes are shown in the score; op0 operates on one node, but op1 operates on two nodes. Hence three processes on two nodes. Even though the two nodes have the same fastname, they count as separate nodes. BTW some passive stages DO lead to operators; typically import or export operato...

I have now had experience in many different business milieux (what iamnagus was calling Domains), but had to get started in one. Success there led to others. The business analysts and subject matter experts are other people - I use their output as my input.

These are discussed in some detail in the QualityStage Essentials class offered by IBM. Have you done this class?
The one is essentially a measure of the probability of a match, while the other is a measure of the probability that, if a match is found, it might have occurred by chance.