DSXchange

I don't think Ray quite understood your original issue. I believe you've answered your own question anyway and just needed some confirmation. I believe you are correct, there is no configuration ability within the config file. I believe PX is network ignorant.

Environment variables have to be setup in the job as job parameters. As for getting any variable into a subroutine (I assume you mean before/after transformer/job subroutine call) you have to pass it as the argument. Your subroutine needs to get it from the argument. Otherwise, you will need to do a...

Just choose disable read caching on the reference and don't select write caching to the hash file. Now every row is immediately written and available to read. Don't mess with the locking, you can get yourself into trouble if you are not totally understanding how hash files and locking work. There's ...

Basic difference: TX is a different product specific to realtime processing, purchased by Ascential from Mercator and incorporated into the tool set. Server is the original batch ETL tool developed by VMark/Ardent, and PX is the high-volume batch ETL tool acquired from Torrent.

You can take the bitmaps in your client directory and modify them to taste. That gives the appearance on the outside of a different product, but when you drill in to every stage it gets tedious. Making your own graphics is great, but it looks really lame and is a lot of work. It's just a pathetic is...

No, I said "add", so your WHERE clause would be:

You can't span transactions across separate OCI stages, much less OCI stages across jobs in one single commit. The best method left to you is to load work tables and then use an SP call to merge the data and commit.

I'm sure IBM wouldn't mind, but you're still dealing with Ascential. Just to get approval, how much editorial/final say rights will you have to sign away?

A patch is always good.

Disclaimer: I know nothing of Teradata SQL

I'd guess the t1.dt_id casts from a julian date to a char for this comparison


Does this query work if you add

What does the date matter? Isn't the point that the date is unusable because it's so old? Use an integer comparison to validate that the date is reasonable, I'm sure you can pick an arbitrary point in time, say 1500-01-01 and go forward from there. Just reverse that to the integer julian value and i...

Cold!!! The storm blew south of Tampa, sucking cold weather our way. It topped out at 70F today. I can't wait for it to get back to 85F.

Just a few stage variables and a couple of constraints in the transformer will do the trick. Once your condition is met, the stage variable should update to reflect that the condition is met. Use that stage variable as a constraint on the other output links.

I mistyped, I meant the transformer. I went back and fixed it, but you must have read it too quick. Give it a shot and see if that fixes the problem. Datatype discrepancies between databases have to be adjusted, I suspect that not at VARCHARs are created equal.

Have you tried spooling to a sequential file as well to see if the results are the same? I suspect that the straight link between stages is introducing some issue with the metadata compatibilities. You see, if you import the metadata for the source and target separately, you're only allowed one set ...