Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have one fact table and 7 other tables which are connecting to fact table through left Keep. When I am applying left join then It is giving me General Script error, may be due to data size as data size in fact table is 67 million. That's why, I am using left keep.
I am creating adhoc report in which one measurement is there (Count(Distinct A)) but performance is quite bad. Can anyone give me some idea to improve the performance.
Can you give data sample? 67 millions is not so much anyway