Incremental Inserts / updates
Hello Gurus,
I have researched this forum + googled before posting this thread. I need to incrementally update one Oracle table from another. I am using the LKM SQL to Oracle and IKM Oracle Incremental Update. In the Diagram tab, I have identified my 'Key' as an ID column and the 'Name' column. For both columns identified as 'Key' I have the Insert and Update options checked. Everything is set to execute on the Staging Area. My remaining 3 columns are mapped and only the 'Update' option is selected.
The first time the interface is executed, all rows are inserted. To test the incremental update, I deleted three records from my Target and tested. No records are inserted.
Questions:
1. Can someone please define the Update Key? I am confused from a true 'key' reference [primary etc] and how it has been explained in the documentation. Does the Update key [or those columns identified as 'Key'] identify those columns to be compared between Source and Target to determine which columns should be updated? So if I have 15 columns in my table and I want to update every column in the target that is different from the Source, would I make all columns as 'Key'?
2. Should I have 'INSERT' and 'UPDATE' selected for all 'Key' values? I only want to insert a new record when the xxxx_id source column has a record that the target does not.
3. Why is the INSERT failing? The Interface completes successsfully but no records are added. I am using all of the Defaults in the IKM Oracle Incremental Update.
I've been struggling with this for a while so I really appreciate your guidance and recommendations.
Many thanks!