The optimization techniques depend on the type of data warehouse product you are using and whether you are able to load the data with maximum throughput after lookup matches from dimension tables.
Once the data is ready, you can try to load them to table using Bulk components which will give better performance. If you are having any issue with any specific table load, we can analyse it further.
