DSXchange

Use Sample stage with Skip = 4 but otherwise a 100% sample.

It should look like this: ProcKeyLookup 001 F 002 ProcKeyLookup 003 D_ProcKeyLookup How was the hashed file created? It seems to me that the VOC entry is corrupted and, if field 3 is correct, so too is the hashed file itself - ProcKeyLookup directory should contain only DATA.30, OVER.30 and .Type30 ...

Char(10) to Integer may be illegal, if the value is greater than 2^31-1.

I don't think you can do it that way. What you can do is construct the entire SQL statement outside of the job (in a sequence) and pass that as a parameter to the job.

Why? What's wrong with what's been proposed? How many times are you going to ask "is there any other way"? This is not some kind of competition.

Can you use quoted identifiers in Teradata? That is, "SOUNDEX" is a column name, whereas SOUNDEX is the name of a function.

You neglected to mention that little fact.

I don't believe there will be a solution that does not involve saving the content of the archive to disk.

You left off the quote characters. LIST commands (including LIST.ITEM) are not permitted two file names on the command line.

What is the full syntax of the dsjob command that you are issuing? In particular does it include -user and -password options?

Transaction isolation level is a property of the ODBC API. Definitive explanations are available in Microsoft documentation (Microsoft are the creators of the ODBC "standard").

Disappointed to find that you haven't enrolled on the Metadata Workbench Essentials class starting today in Singapore.

Not easy, and I'd probably guess impossible in a single job. You can read the SQL from the table in one job, load it into that job's user status area, and read that when setting a job parameter to contain the SQL in a second job. Use the first job's $UserStatus activity variable to get the SQL state...

There's no reason a random number would not generate duplicates. They're random, after all. You can even work out the probability of it occurring, if there is a finite domain of values from which the random number can be selected.

What if you were to use tar as the filter command in a Sequential File stage?

Yes, although the preferred technique is to add it using the Administrator client.