DSXchange

In other words, the version they are running. Thought perhaps the issue was related to the earlier behavior.

What version did they start allowing stage variables to be nullable?

You can also use the Sort stage to put them in order and add a Key Change column, which would make your stage variable derivation even easier (you would only need one).

Asked for real examples, not really sure that is what we're getting. Are you showing us the fact that the word "NULL" is in the file, those four characters? If not, I'd need to see exactly what the file looks like to provide any more help than I already have.

A ".csv file" is a delimited file. So the test I posted isn't working? If so, can you show us some real example records from the file where you have some empty fields you want to be NULL?

A couple of things. First, nothing is ever equal to NULL which is why the first check fails. Secondly, there are no true NULL values in a sequential file which is why the second test fails. You should be able to test for an empty string like this assuming we're talking about a delimited file: IF Inp...

As to the question in your subject, see if this helps:

viewtopic.php?t=149667

Also, from what I recall "Auto" partitioning with a lookup resolves to "Entire" which may be less than ideal depending on the size of the lookup dataset.

Any idea where it is stuck, meaning stuck doing what exactly? What's the last log entry you have for the job?

Define "stuck" and how you are partitioning the lookup.

I really doubt this is related to your dataset node question... which has been asked and answered quite a number of times here.

I just had a close look at transformations in this particular job and this particular column is used in join stage as joining key. Its coming as interger from ref link while source has varchar datatype. Hey, it happens. We source from Oracle Federal Financials and have to do joins like this all the...

Damn.

How did "zoned" come into this conversation? Did you get your hands on the COBOL FD?

Or escape them. And I wouldn't wait two months, more like a small number of days... seven, perhaps. Once the job completes that data really isn't all that useful to a user.

Stumbled across this in a Kickstarter email and thought I would share it as I found it very interesting.

List of most common Unicode characters

I had no idea there was a Unicode character for snowman. ☃

:D

I found what I was looking for in the KBA code that I have stashed and it is a reference to @USER0 which was what I was thinking of. Was I in the right ballpark at least?