Q: What is a data warehouse? Fetch all the data from different OLTPs, make it coherent (in a consistent manner), load to the Data warehouse,…