DSXchange

Well... As a part of the ETL design, we are trying to use Change Apply and Change Capture stages together as a reusable component in ETL processing and do not wish to hard code the key values in. That's why in the change_mode of Change_Apply stage I have set "Change Mode" value to "Al...

nop i have not....

ray.wurlod wrote:This message suggests that you've used CHANGE_CODE more than once in the setup of your Change Apply stage. Check your work.

I have created the following process for Change Capture: processing_table > ChangeCapture > delta_table archive_table The delta_table has an additional column change_code. Run time propagation is set to on and the change capture stage in parallel datastage job works fine, with the change_code popula...

Actually, we too are having difficulty with DUPLICATE IDENTIFIER fatal error: I have created the following process for Change Capture: processing_table > ChangeCapture > delta_table archive_table The change dataset has an additional column change_code. Run time propagation is set to on and the chang...