Load Tables

[#1]

I am loading a script which has 40 EXCEL files/sheets included in te script. It takes a long time to load the script. I left it to load for more than 3 hours, but it did not do it. There is only a total of 20000 rows in these 40 excel files. any idea what could be the reason. Please help.

[#2 · Accepted solution]

verify sintetic key . if it end long time.

[#3]

Thanks Ivanildo Buarque

It was becuase of repeating fields in all the tables. There was a huge relationship between tables. I dismantled all tables and created fresh.