DSXchange

And exactly the purpose of a Lookup Fileset.

Lose your hesitance.

I think the best piece of advice is to stop trying to build PX jobs like they were Server jobs on steriods. Unless you have some complex bit of lookup data that several processes need to leverage then just do the lookup against the data itself rather than building datasets like they were some kind o...

First thing - typing in all caps is considered SHOUTING so please knock that off. There's no need to shout.

Secondly, show us. Post the 'calculation' you are using and the precise datatypes involved and then show us the 'in correct' values you are seeing. Then maybe someone can help you.

Honestly, if you had "handled nullability" you wouldn't see this message. Have you tried an exact match search here for your Exporting nullable field without null handling properties message? There are 47 matches out there for it, seems like one or more should provide some useful informati...

A direct download link doesn't exist for everything. As far as I know, there's still some that you need to request of your official support provider so that they can make it available for you.

As noted, you already know how to convert one to the other, so what is it you are worried about or having an issue with? Not getting an expected answer?

Data types? Precision?

True, if the proper analytical functions available, but it's simple enough to do it in the tool as well.

Still, based on your example it will need to be sorted by something, be it the Sort stage or your source (if a database) or something on the command line. If you do it in your source database, then you can set the stage to "Don't sort, already sorted" but still use it to create the column ...

Requesting you first do an exact search here for that entire Traceback message and see any of the 19 other matches on it help at all.

Not everything is configurable and I've never seen anything documenting how to change that. However, doesn't mean it isn't, hopefully someone knows something regarding this.

"sa" is your surrogate? Regardless, it is warning you that your target won't be able to hold all possible generated values. So, what is your target for this?

And here I thought it meant Orchestral Manoeuvres in the Dark.

Also curious why you feel any need to move it elsewhere. Space?

The post is marked as a Server issue, even though we're in the PX forum, so I'm guessing there's no nodes involved here. Once confirmed, I'll move the post. :wink: The Server sort stage is not known for its speed. A better alternative would be any kind of command line sort option and you could lever...