DSXchange

Paul's approach does actually use IIS, but sets up the address verification as a web service, so that your "outside" application can invoke it.

As far as I am aware it is not permissible to use AVI outside of QualityStage.

With knowledge of Java, and the ability to work with the Java stages, you can access just about anything. The real question is whether or not this will provide you with information that can be useful in a structured data format, or if a different solution is ideal due to unstructured data. Note also...

Actually, Teej, such blocking operations are perfectly possible, feasible and even normal in server jobs. Put another way, in server jobs a passive stage can have an input link (writing) AND an output link (reading). When the job runs, the output link is not opened until the input link has been clos...

In the real world projects do become corrupted, because people do not pay attention to having enough disk space (for example putting disk and scratchdisk resources on the same file system as the projects, and by whatever means allowing the disk to fill, or by not purging logs so that they exceed the...

My guess is that parameter values are not being passed correctly from the sequence to the job.

Check that the Job activity is configured correctly, and check both the log of the sequence and the log of the job run under its control, to see what values were used for parameters.

Sorting isn't recommended either (since it consumes resources). Unless you need it. I have no problem at all mixing job types or using the BASIC Transformer stage, in those circumstances where it's warranted. An admonition that originally came with a caveat appears to have metamorphosed into some ki...

Craig's recollection is correct. The fact that it's offering a message handler in the log view from a sequence is probably a bug.

How about copying them before retyping to the null class, then working with the copy? I assume that's why you're asking about using a variable. (It's something I haven't tried to do, so can't offer definitive advice. Why not try it?)

Check the permissions on the file and its parent folder, and determine under which user ID the jobs run (you may also need to check group membership).

Bonne chance!

Different countries have different levels of verification available. As you note, the US and Canada (and Australia) allow quite fine-grained verification. This is not the case in various other countries. It's mostly a function of how much detail the postal authorities make available.

I'd be thinking to use a Data Rules stage implementing in_reference_column rules.

Andrew S Tanenbaum wrote:The great thing about standards is that there are so many to choose from.

See also https://xkcd.com/927/

What exactly does the Execute Command activity do? That is, what command does it execute?

chulett wrote:I think I agree!

Therefore you are a yam.

Maybe you could implement validation once the data have arrived in Netezza (maybe into staging tables)?