DSXchange

Could you share the details of your solution, please?

149809.94 isn't a valid integer so you'll need to use a different target data type, one more appropriate to that value - a decimal.

Let's start by getting you out of the FAQ Discussion forum and into the proper one... and done. You'll need to start by letting us know what DS version you have and what O/S your server components are installed on.

You haven't specified your target stage - is it a Teradata Connector or one of the legacy stages? This may help in either case. If you are going to need more help, you'll need to provide more details about the stage and settings / properties you are using on the target side.

That just looks like a message about the error, not the error itself.

Have you considered building a looping Sequence job? Optimize the file load and then slam them through one at a time. Or make it multi-instance and have each instance take a portion of the file set to iterate through.

So a visual comparision? Get yourself something like UltraCompare for tasks like that.

You are in the correct forum. If you haven't already, send an email explaining the situation to "editor@dsxchange.net" (note the .net not .com) and see if that helps at all.

So if that does "fix" it and you want to go back to running on multiple nodes, we'll need to look at your partitioning.

To quote an old version of a recent movie: "Clever girl!"

Not seeing what is wrong with the original code as posted, however.

John, a couple of things. Use the Reply to topic link rather than quoting everything from the post you are replying to using Reply with quote unless it makes sense to do so. Also it doesn't make a whole lot of sense to use BBCode tags like for quoting, bold, italics and other things and then check t...

Right... that function doesn't do "full" division but only returns the quotient, an integer value. That's also why the documentation says that if you want to know the remainder to use the Mod function. Functions like that are generally for specialty situations, if you just want to do "...

<cough> dssearch </cough>

Me? No clue and no way to get one.

What about the definition of the field where you do the math? While the 'remaining stages' are important as well, so is the place (transformer, I assume) where the division is done.

Then you've defined the target data type incorrectly. Should be a decimal with the proper precision and it sounds like you've got it defined as an integer.