DSXchange

The value " 4 " is reported. This suggests that the field has surrounding space characters, and perchance its data type is a numeric data type, such as Integer of some kind. You need to fix either the data or the metadata. Actually there are 3 log records that are the same, so it is not e...

sud wrote:Hey,

What is the datatype of Field "STATE_AGENCY_KEY" ? and can you please find out the record 4 and post it.

Decimal, length 15 and Nullable

Thank you for the reply

hi everyone, I have a simple loading job, from flat files ( 5 of them) to an oracle table. it compiles, and doesnot give any run time error either, however it gives some warnings in the run time but it doesnot load any records. do you have any idea, why? The last portion of the log is below, the fir...

Becuase its the PX version running on AIX unix , yuo are gitting this error, Thier is a Patch for thix issue to fix it permenently. you can contact Ascential Support team to get this patch........ A quick fix would be a restart for the job. Thank you guys for all the comments, I don't think anyone ...

Hello everyone,

I was wondering if anyone knows about this error I got while running scheduled job at night, the error is not descriptive it says
"node_node1: Player 2 terminated unexpectedly." the next error is
main_program: Unexpected termination by Unix signal 9(SIGKILL)

any comments?

See page 5-15 of Parallel Job Developer's Guide which describes the (mutually exclusive) Null Field Length and Null Field Value properties that you can use on the Inputs link Format tab in the properties editor. Which one is correct for you will depend on the format of the file you are writing. tha...

You can specify how null is to be represented as a record level property. You can override that at the individual column level using Edit Row (right click on that column in the Columns grid to expose the menu from which you can open the Edit Row dialog). I just became a premium member to read your ...

Hello Everybody, I have a problem with a stage output in a job which has many column value as null. I want to write these data to a sequential file. I have to find a way to handle nulls for every column, not only for one. there are many columns which might be null, and I don't want to edit string pr...

Helloo Guys/Girls, I have a simple question, when you are joining two tables by using join stage, do you have to sort and partition the tables by using a sort stage or is it enough to click on the auto box inside the join stage. in the reference book it says it is enough to just click on the auto ch...

Thank you ver much Ray, it looks like you summarized it very well. I know a little bit about DS server edition but I don't have much experience on it either. I think it is not necessary to be very good at DS server edition (or to know completely) before you start to DS EE, is it? so can you say that...

Helloo guys,

I am very new to DS EE and I am trying to learn it just by reading now, I was wondering which stages do you use most in DS EE. so that I can study these stages. And also any suggestion for learning DS EE will be appreciated.

Thanks in advance
Cetin