DSXchange

There is no space allocated per Project, it's just a folder. The space is controlled by size of the partition you've created it in and it serves all projects.

If this is working for you then good. My only thoughts I've already posted... I educate people working for me to not use those " = 1 " or " = 0 " comparisons, they get called out and corrected during the peer review. One example: If SVPreEmp = SVCurrEmp then 1 else 0 Should be si...

What kind of an "upgrade" was done?

They haven't posted in three years. Why not let us know what issue you are having?

I needed to clean up the quintuple posting you managed somehow ( I think that's a new record :wink: ) and then moved you off to your own post. Similar != same, so best to post your own details and link back to anything older you think may be relevant. As I've done here. First question is easy - do ...

True... except for the fact that the code I posted specifically checks for null.

Make sure you define and initialize the variables properly. The first is a three character string set to @NULL and the second is an integer set to @FALSE in my case. This so svFirstDept shows 'ABC' all the way down.

It is writing them but not committing them, I'll wager. Use a small transaction size or an ODBC stage so you can specifically issue a 'commit' when needed.

It may speed up processing, maybe even considerably. But as always, it... depends. On many things. SMP or MPP architecture, I/O bandwidth, available CPUs and memory for sorting / hashing / I/O buffers for example are needed. And generally it doesn't help a simple select like this one. Never mind tha...

I just wanted to make sure you were on the latest (last) 7.x release as, from what I recall, all of this $PROJDEF goodness was actually supposed to work.

What's your version?

Yes, it could be and that would be an issue to raise with your DBA.

The comparison operation should break at the first instance itself. So... you only want the first two records and all records after the first 'break' should be skipped? If so you'll need different code... something like: svFirstDept => If IsNull(svFirstDept) then DEPT else svFirstDept svIsBroken =>...

Welcome. And no, it's not. From what I recall from reading other posts here on the same topic, you would have to leverage Java to source from a URL.

please tell me where to use @FALSE constraint. Constraints are an element of Transformer output links. For the record, you could have added one before the Sort stage and set that value there to gauge how long the source portion of the job consumed. The remainder would have been either the sorting o...