Analytics Software

Greetings all,

I'm trying to do incremental update load from Flat file into Oracle. I followed the user guide to execute on Target, mapping is for Insert only, defined an alternate key not using the mapped column with have specific sequence. Tried both sequence syntax # versus : on the sequence name. Tried also adding a separate data server for the staging area. Still won't bump up the sequence for each row of data loaded. Just does it once only.

Documentation says to have separate INSERT and SELECT commands executed on different connections. But documentation also says if you are using incremental update IKM to be sure the update key does not contain a column populated with the sequence. So I gotta believe it's possible to use incremental update with a specific sequence... It's just that incremental update IKMs don't appear to do separate insert /select commands ??? I'm only using specific sequence because that's how the existing application dictates.

Anyone have ideas or was able to make this work before??