Problem while connecting with oracle

sdasavi · Post by **sdasavi** » Wed Mar 09, 2011 5:00 am

Hi,

My job design is, two sequencial files (source). Target is oracle database. In between i added the change capture stage to record changes. The output is given to filter stage, by using change_code in filter three outputs are given to three modify stages (update, insert, delete). All the three are stotred to oracle database by using odbc connector. Whole process is done through run time propagation.

My problem is I am getting insert data to oracle, but the problem is with delete,update stages. And I am not having any primary keys from source files. Can anyone please solve this problem.

battaliou · Post by **battaliou** » Wed Mar 09, 2011 7:28 am

Define your primary keys in the output columns of your filter stage.

sdasavi · Post by **sdasavi** » Wed Mar 09, 2011 7:58 am

battaliou wrote:Define your primary keys in the output columns of your filter stage.

Hi Battaliou,

The source files are sent by the client and there are no primary keys defined. Is there any way to solve the logic with out defining primary keys

jwiles · Post by **jwiles** » Wed Mar 09, 2011 8:44 am

As the Oracle table apparently has key columns defined, your data needs to have those columns defined as well. If they do not exist, or do not have the correct data, then you will be unable to update or delete existing records. It's just the way database processing works.

Determine from Oracle what the primary keys for the table are (ask your DBA if necessary). Then determine which columns on the source data will map to those columns, either directly or through a set of business rules. I would expect that information to be available somewhere, but you may just have to make a best guess.

Regards,