DSXchange

Funny but that was news to me, guess I never noticed it. Good to know! :D

Left that part for you.

So, what is your database? When you say "number" do you mean an Oracle NUMBER field with no precision (rather than something like NUMBER(10) in other words) or something else? Who decided it was a uint64? And if your data types are correct, how were you planning on fitting everying from th...

I was wondering what a "unit64" data type was. :wink: A "uint" is an "unsigned integer" and the warning is telling you that there is a high probability that your unsigned 64bit integer source data won't all fit in your signed 8bit target integer field. You sure you have...

Ernie gave you the answer to that in your other copy of this post.

Wrong forum... it was also re-posted (and is being discussed) here if you want to contribute:

viewtopic.php?t=132739

I'm not aware of any documented limit on columns, you'd have to ask your support provider for that. What about the single/multi node question?

The other thing I would look at would be to follow the instructions as documented - create a role, assign the grants to the role and then the role to the user. That is not equivalent to direct assignment of grants to a user, btw. See if that 'fixes' things. If not, then I'll jump right in the same '...

You could also look into the Sort stage with the Add Key Change Column option enabled to see if that helped simplify the identification of your 'duplicates'.

Make sure your ORDER BY in your SQL matches the key column(s) you specify in the Sort stage and that their data types match. A numeric sort and a string sort of the same data can output data in different orders and trip people up sometimes.

So much PC goodness from Uncle Ray that people miss out on.

I do believe that is required now, better get crack'n.

So... you mention the "more than 500 columns" part as you believe that is the root cause of your problem? Also meaning you can successfully load in the same manner other tables as long as they have fewer columns? I'd also be curious if this fails with a multi-node config but runs ok on a s...

Thanks for the reply, unfortunately both of you are considered premium content therefore I cannot read most of your comments. And yet you show as a Premium Member, so should be able to. If you have paid for that but it's not active yet, best to use the Contact link at the top of the page and have s...

Well... simply put, you've asserted that the data will be hitting the Sort stage sorted in a certain manner and... you lied. It's not.

You need to figure out the disconnect between what you think you are doing and what you say you are doing.