DSXchange

Ok, select the APT_DISABLE_COMBINATION environment variable to false in you job. Or if you have transformer, make the combinable mode to false.
So that you will get the exact stage name where the error is poping up. How huge is the input file that been processed?

Hi Vinod, Welcome to Dsxchange :D !!!! This has been covered already. If you do a search on 'Unbalanced input from partition' you might get some results. Its basically the number of records that get partitioned are not equal or mostly been forced to flow in some of your node. To get more details, ex...

Dont you have Transformer stage?

Its the power of DS EEE. Configurable items can be exploited. It doesn't require the restart of the server (in most cases) or re compile of the job. DSEngine is built in a generic form, and it should be configured to each site (with respect to the OS and Hardware availability). Config file used to g...

What is your current job design (What is your source)?
Why can't you use Transformer?

You are tyring to do an implicit conversion from decimal to char / varchar.
You can try an explict conversion.
But what will the file used after it been created?
Can decimal field be filled with space?

Oracle_Enterprise_0, most probably in your input stage, the conversion is taking place.
Check if your source table as Discount_id as varchar or char(40). Which you are using it as number in Datastage.
If its not the case, try using CAST function in Oracle for any change.

My career path is up side down. I started with PX and moved to Server now.

View the controller file where you can get the details of all the data file and its location. You can cat those files directly and manupulate it. If delete the data file, make sure you delete the controller file as well.

Disabling the combination of operator will eliminate the warning.
Could you explain the job design along with partition used.

But If I recall properly, once I did testing on '*' in filter, which didn't gave your the expected output. I posted the result in this forum as well in some of the post. But I dont have access to test now.
But Iam sure that, its works with patter matching. Like [a-z][a-h]...

As noted, monitor the same with one or two jobs running in parallel.

Better you change all you field to Varchar and read it again. Where in most cases, you can expect the Whitespaces to be trimmed automatically. Atlest with the functions provided by Ray. By this you also save the space used by your sequential file if any.

Hi Diego,
I could see your post in other topic as well. Could you post the exact error message that you get.
The two post giving giving out two different error code.
If its one among that, you can follow up on that particular thread, else you can start a new thread of your own.

Kim, your logo looks much colorful and attractive.