DSXchange

hello all, I have a requirement where in I have to use a oracle table for change capture before link and after that doing some transformation and ultimately loading to the same oracle table. Does it cause any performance issue , using the same table to read and write. I read one article in dsxchange...

hello all, I am still looking for some help for this topic. can anyone throw some more light.Can i do it in 2 jobs, like loading into a dataset first and then in a seperate job loading from dataset to oracle. does this help. because the DBA is not so happy dropping the indexes. i tried the options a...

hello, Thanks once again. Yes I did try the $APT_ORACLE_LOAD_OPTIONS. I set the ROWS= 50000 or so.but it really does not work . I have tried the direct=true and parallel=true also. Anyway let me check with UNRECOVERABLE option that you suggested. One thing I would like to mention. There is index men...

hello, thanks for the ideas. well the target has index on some of the columns. source does not have any indices. I am using "load" and "append" method for loading into the target. this is a one time load into the target which does not have any records at all. I have tried the opt...

hello, thanks for the ideas. well the target has index on some of the columns. source does not have any indices. I am using "load" and "append" method for loading into the target. this is a one time load into the target which does not have any records at all. I have tried the opt...

hello all, I have about 100 million records in an oracle table. i am trying to read it by using oracle enterprise stage. My job is quite simple, reading data from oracle followed by transformer , surrogate key generator stage and then loading into oracle again. i am using oracle enterprise stage onc...

hello, Well i have a doubt since long. There is something I am not very sure about the fixed width files. i have searched dsxchange regarding the same but could not find the exact answer. the problem/confusion is regarding reading fixed width files. If i have a fixed width file with total record len...

Hi, We have 5 sequential files getting joined using Left outer join. Only the master record has the data and no child record is having data. But when the data is coming out from the JOIN stage is displaying 0 values into the decimal fileds that are coming from the child records. Where as our requir...

Hello, I have the following function in server job: iconv(column_name,"MX") I went through some documentation to understand that it basically converts the number from decimal to hexadecimal. is ther any equivalent function we can use in the transformer stage.However the incoming columns is...

hello, I have an issue here. I am doing a sql query from oracle enterprise stage.Here i am using some aggregate functions like count(*),sum(colmn1). Its meta data is defined as integer in the job. its throwing errors like floating point error. i dont hv the exact error message with me right now i wa...

hi there,


even i had a similar dobt regd this.so ultimately where do we have to run this command. is it the path where the project is installed or where the DSEngine is there.

thanks

OES? Are you using Oracle's Express Edition? As far as I know, that is either not supported or known to not work. :? I suspect 'xrmigrator' is a typo. ... hello chulett, well sorry for the misunderstanding. what i mean by OES is Oracle enterprise stage. the xmigrator is tool used for migrating jobs...

What is xrmigrator? View Data works differently in server and parallel jobs. It always displays the decimal placeholder character in the parallel version, as well as adding leading and trailing ze ... hello ray, thanks once again for your quick response. well xmigrator is the tool that the team mem...

What is xrmigrator? View Data works differently in server and parallel jobs. It always displays the decimal placeholder character in the parallel version, as well as adding leading and trailing ze ... hello ray, thanks once again for your quick response. well xmigrator is the tool that the team mem...

hello, i am doing some migration jobs from server to parallel(7.5.2)I have a ORAOCI stage in server and after using xrmigrator i have the OES in the parallel version of the job. Now the table has some number fields which are read as decimals in both of these stages but when i do viewdatea in server ...