I'm working on my fact table and I want to create history table for each dimension without using slowly changing dimension because my data flows are bulky and it will take too much time to finish the process of feeding the fact table ? Generally, slowly changing dimension works with dataset having less than 1000 records.
I’ve used SCDs with 100s of thousands of elements and even millions. You’ll need to optimise your table, create indexes, etc, but there’s no reason not to use them.