DSXchange

'Does not refresh'?

Sure, US-ENGLISH uses "." for the decimal and "," for the separator so if that's what you need that is the proper solution. What was it set to before?

If you got the information you needed, can you please mark your post as Resolved using the button at the top of the page?

For both? You need to be precise. If so, have you tried changing any of the 'Filter' options?

This has nothing to do with individual projects and everything to do with the amount of disk space you have allocated for datasets in your config files. There's no limit other than your hardware.

So... it runs ok when there are records to load but doesn't when there aren't? Worst case you could split the job - land the data and only issue the MLoad if there's date to load.

Or you could just wait for someone who actually knows something about Teradata to respond.

You're going to need to be more specific. Are you talking VSAM/ISAM files or something else? What platform?

Ah... thank you.

I'm not sure if there are any stage in PX that would allow output to dynamic files, perhaps the External Target stage? Server allegedly does - the Folder stage but to be honest I've never used it in that fashion. Or you could always go the 'build op' route and put together something in C++ to do tha...

Figured you would search for that. An exact search for message handler file will turn up several discussions on the topic.

Automatically? No, not that I've seen. You can manually copy over the message handler file itself, however.

Nice that you went back and added the volume in the original post after the fact. Classy. And if speed is oh so critical then they should be willing to invest in the tools needed to make that happen, whether it's the Enterprise Edition or adequate hardware or a high-speed command line sort utility. ...

That little fact should probably have been in the original post, don'tcha think? :? Regardless, the only issue with that volume is the sorting. Probably best to attempt that outside of a Server job, say via a command line high speed sort utility. I would also consider bulk loading all three files in...

The way you do everything in a Server job - in a Transformer. Sort the data and then use stage variables and a constraint to allow only the first row to pass out from each 'duplicate group'. That or leverage the destructive overwrite functionality of a Hashed file with the proper fields set as Keys,...