Could this be it needed the privilege to create the Talend DQ Mart in the first place? |
This was the case, in the Talend client despite
not being able to create the necessary sequence in the first place (i.e. when I pressed the DQuality->Report->Database settings-> Check button) the message back
reported no errors and said the database was well formed. However it hadn't built the necessary sequence as it didn't have access.
To correct this we had to drop all the tables and views, assign the create privilege permissions and then recreate the DQ Mart DQuality->Report->Database settings-> Check button.
Thanks,
Dan