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.
Problem while connecting with oracle
Moderators: chulett, rschirm, roy
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,
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,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.