Dictionary Issue - Base Data Cleanse

Hello Experts,

Using Data Services 12.2 .In my dictionary there are 590 classifications are there(I think this is the maximum limit after that it giving error unable to allocate index ,indexes are over).my source contains 16500 records ,i ran this job on server with 4GB RAM ,for loading 10000 erecords it took 6 hours i forcibly killed the job after that. i tried with run as seperate process but no luck.Please let me know how to tune this datacleanse transform to improve the performance.For testing purpose, i am using query transformation after that will be using BDC transformation then output table .

Please give your inputs?

Will it be possible by splitting dictionary and doing so the performance takes a big hit?

Thanks