DSXchange

(Auto) gives Entire as the partitioning algorithm on the reference input link to a Lookup stage. On an SMP environment, Entire is implemented by placing a single copy of the data set into shared memory. Depending on the circumstances, this can be seen with other complex stage types such as Transform...

Be consistent with your use of the extended property Unicode on your strings.

Yes, provided that you do NOT check the "perform sort" check box on the Partitioning tab. That would force an unnecessary re-sort. The upstream Sort stage, being directly on the input link to the Aggregator stage, suppresses the insertion of an unqualified tsort operator. You will still se...

Yes, I thought that there may have been a log stored in RT_SC32. Obviously not. Need to think about it for a while.

No. Use a Sort stage.

Remember from the transition class - one task, one stage.

Read the documentation on istool. What is it meant to "export" into a deployment package?

Output on a group change occurs if the Sort, rather than Hash, method is employed.

Look in the RT_SC32 directory within the ANALYZERPROJECT project directory on the server.

The last line in the file is missing its line (record) terminator.

No.

Were you to follow my advice you would mention, in the Trim() function, the stage variable whose value has been initialized to Char(9).

You can not bypass the check for existing row. Most efficient way is to load a hashed file with just the key values from the target table. If there are potential duplicates in your input stream, you also need to maintain the hashed file as rows flow through.

Specify the tab character in the Trim() function as the character to be trimmed. The tab character can be represented as Char(9). Performance tip: Evaluate Char(9) when initializing a stage variable (perhaps called svTab). Then don't provide a derivation for this stage variable in the main part of t...

A full outer join is not the same thing as a Cartesian product. Why not create an example with three rows on each input? Describe your expected output, and what you actually get. Then describe what you're doing on the Mapping tab of the Output link, which is where I think you're missing picking up i...