Skip to Content
0
Sep 16, 2019 at 10:17 PM

Data Cleansing Advisor Error unable to access staging table

64 Views

Hi, I'm trying to generate a DCA using a view that has multiple joins and a filter. To finally get the DCA I had to create views on top of views.

I needed to take Business Partner information therefore I tried creating 1 view joining the BUT020, ADRC (inner join on address number) then the additional table was BUT000 (inner join with BUT020 on partner ID) I had 2 filters one with ADRC nation is null and BUT000 XBLK is null. Can someone tell me if this is normal behavior for DCA not to work when joining multiple tables in one view with filters from 2 different tables? I was receiving the error " unable to access staging tables". Content profiling & rules tasks have no errors just DCA.