DSXchange

That's true... and something I considered but from the job description I couldn't tell if that was in play or not. And I don't know how it could ever have worked before and then suddenly started shooting out endless rows... unless someone changed the job and removed the constraint that controls the ...

Excellent that you figured it out. I'm not really following the resolution but that's neither here nor there. However, not really sure what the 'self tangled situation' is that you're leaving this open for - can you clarify?

From the documentation: The data sets input to the Merge stage must be key partitioned and sorted. This ensures that rows with the same key column values are located in the same partition and will be processed by the same node. It also minimizes memory requirements because fewer rows need to be in m...

How can you derive a birthdate from an AGE? Every day the 'birthday' will change. Birth year, perhaps.

Sorry, too much PX on the brain. If you work with FLOAT you'll see all kinds of issues like this so... don't. Probably won't help but do the move from a string field to a decimal with the proper scale in the transformer and then map that decimal to the NUMBER in Oracle. If that still doesn't work bu...

That's basically a Horizontal Pivot - columns to rows.

An unbound NUMBER is stored as a FLOAT so not really surprised you see what you see, in spite of that 'working' with OCI. Define it as a string in your file and do an explicit conversion, see if that changes the behavior.

Involve your official support provider, especially for errors of the "unknown" type.

What's the Oracle datatype?

Yah, nuke the remnants of the Type30 and disable write caching. Also - involve support if you haven't already.

D_Last_Batch will always be created, irrespective of the hashed file type. This is the "Dictionary" which contains the column definitions, etc. I never found that to be true. We would find the dictionary file... sometimes. Never really could quantify when it would be there and when it wou...

Hashed files are the heart and soul of Server jobs, nothing else really works like them and there shouldn't be a need to seek alternatives. Can you detail for us the options you have in the Hashed File stage for both the link writing to it and the reference link doing the lookup? I'm wondering speci...

suryadev wrote:How do I give two columns as keys?

You cannot, much like Highlander "there can only be one!". Choose the lowest as the key.

Done.

For the record, Oracle has a TABLES() function to access and 'unnest' these but loading you use normal INSERT statements. Well, mostly normal as you do have to worry about setting up the constructor properly.

Good job.

Since it worked fine once upon a time, it may have simply been corrupted in a way that the 'Clear' cannot fix. Try deleting the hashed file directory so it is recreated next run, see what happens.