DSXchange

Do you have a DBA for that database? Have you showed them your "Fatal Error: ERROR: 2 : nzlog fopen failed" message?

I would suggest you use a job to do this.

There are many posts here on how to generate a unique surrogate key in a transformer using the various @PART related system variables. I supposed one could do the same by passing those values into a Server Shared Container that does the calculation there... but not sure you could do the same just us...

What are the precision values for those two fields?

Horizontal Pivot, i.e. rows to columns.

Right, but for dfkettle where a rerun solves the issue, that doesn't sound like it could be the case. So, being transient it does sound resource related. Don't know the answer to the file handle question, perhaps others do but the other thing that comes to mind is that AIX specific limit on the numb...

You can't pass in a parameter that contains a parameter, it won't resolve things twice. Your second method should work but use the string you first posted there instead, see if that works.

8.5, PX only, from what I recall.

jack_125 wrote:Earlier I used to set a lookup link on transformers.

So, earlier experience was with the Server product, I assume?

Well... that's a new one. What release are you running?

Don't have any code access right now, but if you are building the string for sendmail you can simply add a "Cc: " tag to the "From: ", "To: " (etc) you already have.

I would think the simplest way to get plenty of examples is to google for "factless fact table". One such:

http://www.rkimball.com/html/designtips ... ssFact.pdf

I don't believe so, they should remain intact even when the hashed file is cleared. If that's wrong, I'm sure Ray will be along shortly with a correction. :wink: Now, if you dropped and recreated it each time that would be a different story... there you would have to ensure they were set properly in...

ray.wurlod wrote:But cat will work, as noted.

Of course, just noting what the DOS equivalent would be.

Not sure if you have a legitimate need to separate #s 1 & 2 or not but you certainly don't need to insert any kind of null record to clear a hashed file. Just setting that Option is all that is needed, it will happen whether you write a record to it or not.