DSXchange

yes, i have 500 columns in the transformer stage and deriations for all will be a single "if condtn then dothis else passs null", thats all.. i use these 500 columns in the target also. For even a small change to the job it takes an hour , but if i do complie wthout any change, it takes fe...

Hi all,
I would want to know if the option "preserve sort order" in transformer stage ( i am doing an inline sorting in this stage) is enabled, will the process of loading data takes more time or more consumption of memory is used???

pls answer this.
Thanks

hi all, I have a job which has about 500 derivations and it takes about an hour for compilation, after even a small change.The job has a source, target and transformer stage on which 500 derivations are made. I would want to know how to reduce the compilation time. pls anyone throw some light on thi...

Hi, I face two problems: 1.Each and every row the input file reads is written on the log, eventhough i have not used the Peek Stage and the log says: "name of the stage.thelinkname_Peek,0: the values and the column names". I used the job parameter - APT_DISABLE_COMBITATION, but currently i...

You can configure the maximum memory (per partition) that the Sort stage will use (by default it is 30MB). Any more than this spills to the scratch disk nominated in the configuration file. Partit ... how to avoid this error? is it possible to change the maximum capacity?how?if i use partitioning (...

You can configure the maximum memory (per partition) that the Sort stage will use (by default it is 30MB). Any more than this spills to the scratch disk nominated in the configuration file. Partit ... how to avoid this error? is it possible to change the maximum capacity?how?if i use partitioning (...

this is the error i am getting after i ran the job: APT_CombinedOperatorController(0),0: Failure during execution of operator logic. APT_CombinedOperatorController(0),0: Fatal Error: Tsort merger aborting: Scratch space full is this related with the memory of sort stage? actually i am sorting based ...

kumar_s wrote:Is it the same status for other jobs? Is it the same on other machine?
Have you tried command line compile, will it take the same time? Was your server busy with something else by the time you complied the job?

how to run the job using command line? wats the syntax?

hi all, I am compling a job which used to take 3 or 4 min in the past, now takes about an hour to complie, the only change is the name of the file. and also not much transformations or derivations are involded in the job. is this some other problem? is there anyway i can stop the compilation proces...

hi all, I am compling a job which used to take 3 or 4 min in the past, now takes about an hour to complie, the only change is the name of the file. and also not much transformations or derivations are involded in the job. is this some other problem? is there anyway i can stop the compilation process...

thanks for ur help ...
i have some problem in the data also, i am correcting it now .. but i am not sure whether that is the problem..

for a decimal value wth length as 9 and precision 2, i shuld define in datastage as below rite? correct me if i am wrong ...
length precision
9 7

becos i still face the same problem ... pls help me in solving this ..

yes, i do have decimal values from input... but i dont think there would be a problem in reading the decimal precision value ... can u throw more light on this?

Hi all, 1. i would want to know wat function i need to use to convert a string value to integer value. 2. Also i get this warning, wen i ran my job: APT_CombinedOperatorController,0: APT_Decimal::operator=: the source decimal has even precision, but non-zero in the leading nybble, or is too large fo...

compilation message : *** Internal Generated Transformer Code follows: 0001: // 0002: // Generated file to implement the V0S2_Xml_Load_Transformer_2 transform operator. 0003: // 0004: 0005: // define our input/output link names 0006: inputname 0 DSLink1; 0007: outputname 0 DSLink4; 0008: 0009: initi...