We are using DQ 10.2.0
Created a mapplet for the rule and added a target table to capture rejection records in the same mapplet. Deployed it as webservice and imported it as a IDQ cleanse function in MDM 10.3 HF1. When testing the function it is giving the below error:
The target table is created in the same schema as MDM.
When i remove the target table it works just fine.
Note: We recently changed the DB ´schema password, and the connection string for IDQ to DB schema was updated with the latest pswd in Infa admin console, connection was tested successfully.
If you run Data Preview on the target table in the Developer UI, does it run ok? The output should be any data existing in the table or 'No data returned' if the table is empty.
In the mapplet the data viewer for the target table is not enabled.
If you just open the table object and run Data Preview on that it will be sufficient to test the details which are configured.
I added the reject table as a target table in the mapplet, which already has an output of its own.
I am able to run data viewer on the reject table, but does that mean that -
a mapplet having a target table can be deployed and used as an MDM cleanse function?
A mapplet containing a standard Output Tx and a reject table can be deployed fine as a webservice. Assuming you have a router or some other Tx to determine which data goes to either the Output Tx or the table this will run fine.
One caveat is if the data passed to the webservice is written to the reject table, nothing is passed to the Output Tx so the SOAP response will be an error message so this will need to be handled.
If you load your Webservice into a tool like SOAP UI, you should be able to test the options.
You are correct, just that active transformations like router can not be used in a mapplet. I tested and got the related error message.
In my case, i am now able to use a target table in a mapplet. Tested it, working fine for my scenarios.
There was a server restart and that probably solved the invalid username/psswd issue i was getting earlier.
Thank you for your help and time.