reading and writing to the same table
Posted: Tue Jul 22, 2008 7:43 pm
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 telling about environment variable APT_DISABLE_COMBINED_OPERATOR to true. Sorry I am not able to remember the variable name. Actually my requirement is to check the source with a change capture stage with a history table based on some key columns, and if the record is not there then insert it to the history table else reject it into a reject file. please help me out as I am dealing with millionsof records.
any help appreciated.
thanks
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 telling about environment variable APT_DISABLE_COMBINED_OPERATOR to true. Sorry I am not able to remember the variable name. Actually my requirement is to check the source with a change capture stage with a history table based on some key columns, and if the record is not there then insert it to the history table else reject it into a reject file. please help me out as I am dealing with millionsof records.
any help appreciated.
thanks