DSXchange

I for one am out of ideas as this is making no sense to me. I suspect we're missing a key piece of information, that or you've found a bug in your very old version of DataStage. Are you 'current' on fix packs for your release? Have you opened a support case? I assume it is no longer being actively s...

Help us help you. I feel like I'm a dentist here, pulling teeth. One.... at... a... time. You need to clarify what the data type is for each of these results since they've seemed to fluctuat over the course of this discussion. If a string then the size, if a decimal then precision and scale. And wh...

No worries.

Note that I added

Thanks.

What happens if you simply "trim" (with no options) the string inside the string to decimal? Meaning:
I'd also be curious how your decimal target is defined, the precision and scale settings.

Basically... I'm trying to clarify your exact issue is with improper data. Does it actually change the "100" to "000" or is it simply the space at the front as a decimal in the peek stage? Because the latter is not an issue at all but simply How It Works.

while using the trim function and putting target as decimal, data will come without space like ' 000.0000' --while testing in peek stage :?: Says "without space" and yet still has one, assuming you mean "with" there as that's how the decimal data type works - that is where the s...

So... color me a bit confused. Sometimes you show "000.0000" and sometimes "100.0000". And sometimes you say "without space" and yet you show one. Is that on purpose or are one/some of them typos? Or is your trim/conversion fun question solely around it removing that &q...

A 'variable' number isn't a problem as long as you know the maximum possible... and that maximum isn't a really big number.

Re: #1... added to the Additional Info area.

Question for support, then. Or an English major. Or both!

Available or available and usable?

In the Big Data File stage documentation there is no such mention and I understand that the Big Data File Stage CAN access non BigInsights HDFS: To use the Big Data File stage, you must ensure that the stage can access the HDFS libhdfs.so shared library, its associated JAR libraries, and configurat...

That's going to come down to what "look for" means here...

Awesome, thanks.

And now in the correct forum.