Hi @David_Wong @Sanjeeb2022 , I cannot break the dataset into facts and dimensions as it is already a different table for all my dimensions. I have to join these tables later or run through parameters through the dataset.
All the columns I’m trying to bring from the message table are important to me and there are only 10 of them. I’m trying to just get data for 3 months for it is 13 M rows and it takes 2 hours in the workbench to run it.
Now since I have so many load problems, I tried using parameters on the dataset. I have tried explaining the dataset and parameter issues over here,
The problem I’m facing now is that the parameter is integer type and cannot show the entire list.
Please let me know if you can help, thanks a lot!