Hello Agata,
I am using 'Data intersecion' to check whether the records are new or existing in table. I am getting error in update because of the violation of key constraint. I want the process to continue and store the rejected records in a file. I am trying the output port but the process fails before it reaches that point. I tried to make the error count fairly large so that the process continues but I don't think it records only the failed records. How can I get the rejected records in a file?
Thanks for your help,
Kasturi
I am using 'Data intersecion' to check whether the records are new or existing in table. I am getting error in update because of the violation of key constraint. I want the process to continue and store the rejected records in a file. I am trying the output port but the process fails before it reaches that point. I tried to make the error count fairly large so that the process continues but I don't think it records only the failed records. How can I get the rejected records in a file?
Thanks for your help,
Kasturi
-
Hello Kasturi,
registering of rejected records does not necessarily work well in a batch mode, but in normal mode it should work properly. I tested the attached graph on MySQL, Postgre and Oracle. In Postgre and Oracle number of rejected records was wrong. In MySQL only error message and error code weren't populated properly, but only these records, that were not put into the database were sent to the rejected port.
Please sign in to leave a comment.
Comments 1