DSXchange

Need a help to understand the performance of user defined queries against the job design for the same logic. I have two oracle tables one with 400K records and other with 200K records and i join these two tables on a key (hash partitioned) and the resulting records out of join is moved to a oracle c...

I tried that option as well now and i see when two null records (with null value of varchar and numeric fields) are compared against its corresponding before result using change capture , the result is a copy record (without any explicit null handling in transformer). I have come across few topics i...

Hi, I would like to know how the null columns has been handled while comparing in a change capture stage. I did a search on related topics which I couldn't get the information I was looking for and hence creating a new topic. I understand that from DataStage version 8.5 explicit handling eg: NullToV...

Thanks for clarifying. As i understand in case if null values not in scope for my join then the null to not null conversion is not required. Also how does DS handles when two nullable keys with data being NULL when joined? i observed that it joins and produces the result as NULL. shouldn't it drop t...

Hello, I have a job design where source and target are oracle tables. There are two additional tables to be joined with the source. Job design is source ->join1->join2->copy->target. In both the joins the key column identified is nullable and the existing sample records has no null values in the dat...

Hi, i have a job which loads from a source dataset to a target dataset ( + alookup before loading to target) with some transformation rules involved which is handled through a transformer. There is a reject link configured for a lookup failure. The reject link has the following stages: copy stage an...

I would like to extract the parameters defined in a parameter set. Since i have frequently changing values in the parameter set i would like to take an extract of the parameter values for validation purpose before proceeding to make any changes in it. Values can be extracted in the exported dsx of t...

Hi, I am parameterizing a oracle view and in my job i should execute a package in before sql and the value returned will be passed to the view which is called in the sql tab as a column generated query. The package execution and the view should be in a single oracle session. I think before sql and t...

Thanks Ray. But how can i validate that this could be the problem and any solution for this? do i need to change any time out setting parameters? Currently my 'Wait for writer timeout' and 'Read timeout' is set to zero in the pipe stage. Also could you please let me know the usage of the above two o...

Hi, I am using sequential stage (Pipes enabled) in my job which will write and read the records. Then using CRC32 function the checksum is generated and the generated checksum will be updated in my target. The pipe file is split in the job so that the sequential file / pipe stage is represented as 2...

Hi All, i have a source oracle stage and a piped sequential stage and a target oracle stage.i am getting error as "column missing". In data there are some special characters that causes such problem. hence i enabled the contain terminators then its working fine. Can any body explain how th...

And also try to use Iconv and Oconv as " mcolen" mentioned. Hi balajimadhav , You have three columns(date,month,year) in the oracle table(source) and one column to be loaded in oracle table(target). my requirement in short: source c1 c2 c3 eg: 10 MAR 2000 target 10-MAR-2000 Try doing a co...

Hi all, my server job is a oracle -> transformer-> oracle stage. in source i have three columns as date,month(eg: JAN,DEC...format),year(all three of varchar2 datatype) but in target these three should be mapped to a date column in target. so i used a routine to map these source columns to target. b...

Hi ,
i am getting the error below when calling a stored procedure in which parameters are passed through a transformer.

<<job_name>>.<stored procedure name>: Must have an output link to declare this type of parameter(B or O).

thanks in advance.

i am getting the same error Error calling subroutine: DSD.Browse (Action=3); check DataStage is set up correctly in project <project Name>( and connection gets broken) every time when i do view data.
any solution for this?