DSXchange

hi chulett, i kept upsert mode as insert only and write method as upsert. please let me know if you need any other information.. hi ray, i am expecting some records to be rejected by database may be for not null column .there is 1 record to be rejected... please let me know if you need any other inf...

hi, i have a job seq file-->transformer--->odbc stage(sybase database). when im loading 4000 records loaded within 10 secs.there is no problem with job. but my requirement is to add reject link from odbc stage,i.e seq file-->transformer-->odbc stage-->reject link(dataset) in this case the same no of...

hi, i have a syabse stored procedure which will be called from stored procedure stage.inside stored procedure user defined error codes has been defined.During execution of stored procedure, if any userdefined error is raised, then i have to capture and load in to seq file. my approach-- row generato...

hi, my job is like this sequential file--> transformer--> syabse enterprse stage.when trying to load records of 4000 its taking 25 mins to load the table.The table has no key columns or constraints or index .in transformer stage there is not much validations.Even for testing purpose i replaced the t...

hi, can any one suggest me regarding the below error.thanks in advance. My target is sybase and i am running stored procedure stage to call sybase stored procedure.in the sybase stored procedure ,user defined errror has been defined.during execution , if any of the user defined error ocurrs, then i ...

how to use type conversion function? wht will be the syntax
decimal to string:DecimalToString(%number%,[%"[fix_zero][,suppress_zero]"%])
10.22 to convert into 1022

please guide me how to do in pivot.

hi, can any one give me some idea how to get the below output. Input Name,Sal,Month Hari,2000,Jan Hari,1000,March Gokul,3000,Jan Ganesh,4000,Feb Jagadish,5000,Jan Jagadish,6000,Feb Output Name, Jan , Feb, March Hari, 2000, 0 , 1000 Gokul, 3000, 0 , 0 Ganesh , 0 ,4000, 0 Jagadish, 5000,6000, 0