DSXchange

sorry Ds! I mean to say if col1 length of 5 then null field value property like'five spaces' the reason for not using modify is it's breaking the metadata mapping & also i need to rename most of the columns.so for each and every column,i need to write a specification. anyway..thanks for your tim...

Thanks DS! I am just writing the data onto a sequential file! if i neeed to do an explicit conv then i need a transformer which i can't use! need to write the buidop code for that. so i am trying to avoid transformer. so.the final answer is if i want to write the decimal field which may have null va...

Kumar, I am just doing a direct writing into a file file should be fixed width (no delimiter required) i/p example Record 1 col1(decimal 5) = 1234 & col2varchar(4) = abcd & col3 decimal(2) = 12 record 2 col1(decimal 5) = 4568 & col2varchar(4) = Null & col3 decimal(2) = 78 record 3 co...

SOrry DSguru! JOb failed saying like "liability_column_rename: Error when checking operator: When binding output schema variable "outRec": When binding output interface field "OID" to field "LIABILITY_OID": Implicit conversion from source type "decimal[31,0]&q...

Thanks!

what if the incoming field data type will be like decimal (length 14 scale 2) ???

Thanks again,Edi

All, Before posting this actually i did a little search on the available forums and tried the something on the Job. But nothing is success full, We need to write a Null field value(Nullable = yes) on a fixed width sequential file.i.e if col1 is varchar(10) then I hope i can give Null field value pro...

All, We are using Modify stage to Keep a few columns of the input(Data from sequential file stage) The Sequential file input stage we are using Schema file Option to define the metadata of the input file. So there is NO metadata columns definition explicitly. In the Modify stage, we are using keep o...

Hi,

We are getting the following error during securities loading.

"Duplicate Transform registration;APT_Transform"

quick response will be appreciated.


Thanks

Hi All

We do have StringtoRaw() in transformer, but not RawtoString().
Is there any way of converting RawtoString()

your inputs will be highly appreciated

thanks
dsedi

Hi Ray

I tried help search, but could not find any thing related to transactional stages. Stages are present in pallete, but no help docs on that.

Please guide me

regards

Hi All

Could I get some info on transactional stage like "Unit of Work".
I am unable to find any specific documents for this.

thanks

Hi Kumar I tried to keep my job's design simple and then trying to use config files one after the other, simultaneoulsy i tried to change various types of partitions. But the best result I got was for Oracle stage partition type =>Entire Config file=>1 node Why is it that even though I am partitioni...

Kenneth thanks a lot for explaining partitioning and pipelining parallelism with a day to day life example. Could you please let me know that in below case 3 Processors, 3 stages (Source=> oracle stage, transformer stage, Target=>Dataset in case of PX and Sequential file in case of Server job) Suppo...

Hi All Just need to get my concept cleared here. In case of server jobs in case of multiple processors, we are able to acheive parallelism by using IPC stage and partitioning using link partitioner and link collector stages. Are these stages overheads which we donot come across in PX for parallelism...

Hi all I am working on PX 7.0, 4 processors AIX system. I used 4 configuration files(1 node, 2 node, 3 node and 4 node) for a particular job one by one to see which of the files will give me best rows/sec performance boost. I was expecting the result to be best for 2 node file as it is mentioned ear...