DSXchange

what is ur job design ? u can go to format tab in out put file and set the delimiter as '|' manually , final delimiter none or end and null field value ''.

Can any one explain in brief about client and server in data stage

what is ur job design?

error due to heap is about allocation of memory resources u need to increase the memory size of the server or try to run fewer jobs simultaneously.

whst is ur job design, are u using join stage in ur job?

do a search on "Pivot" u will find bunch of posts discussed on this topic

Can any one tell how exactly we can partition ,are we talking about partitioning in SQLserver stage like hash.... etc. help me understand

Kris i am using sample stage to split the file in a seperate job.

Thanks Ray for ur reply since i am using SQL server i dont think we have any bulk load stage for SQL server and i am doing initial load so i am loading the data in empty table can u plz suggest some more.

thanks

Hi all , i am running a parallel job as [seq----transformer----sqlserver] i have divided the input file data as 3 million / run (total rows 12 million in original file) though each file has same meta data , every time i run the performance get reduce like 1st runs statistics is 5000 rows/sec 2nd run...

no i am just adding a new column in the transformer which is used in the next stage that is look up as a look up key.

Hi All , i am running a parallel job where 2 seq file passsing through CDC and then transformer then to the rest ,i have 41 rows coming from CDC into transformer but the out put of transformer is only 28 rows and i am getting this error in director error :Transformer_414,1: Caught unknown exception ...

in ur sourse file check the nulable col is it defined correctly,i think if a col is nullable and if u specify it as not null then it get dropped i am not sure some body correct me if i am wrong.

the error u r getting is uasually bcz the row ur inserting is already existing check the logic u r using to update the key value if it exist,somehow u r inserting the same key

cud u plz let us know the job design and error log

select the Null field value option in sequential file in format tab set it as ' ' with no. of spaces depending upon ur col width