I have an issue with Source Rule Table in Insert Rule generated by DSP.
DSP is adding Source Rule Table with the source table, which is WRONG. Because when I re-build the rule after adding few fields (fields which Target Table has), it throws an error.
Let say, I have the fields similar to source table. At this point (re-build works fine) if I execute the insert rule having Source Rule Table as my Source Table , then it gives me PRIMARY KEY VIOLATION.
Can we have this problem fixed?
We are using DSP 6.0.3