Getting Error when loading data in Oracle Database in Upsert
Posted: Mon Apr 13, 2009 3:19 am
Hi,
We have Load Ready Dataset that is output of SCD type2 stage and we are laoding that setset into Databse table in another job using Oracle enterprise stage in upsert mode. Sometime data is loaded sucessfully and sometime loading gets failed by giving error "Unable to insert record into the table" and when we try again it is loaded sucessfully. It gives the random behaviour. Sometime failed and sometime successfull.
Please help..
We have Load Ready Dataset that is output of SCD type2 stage and we are laoding that setset into Databse table in another job using Oracle enterprise stage in upsert mode. Sometime data is loaded sucessfully and sometime loading gets failed by giving error "Unable to insert record into the table" and when we try again it is loaded sucessfully. It gives the random behaviour. Sometime failed and sometime successfull.
Please help..