Hi, a beginning developer here. I have two questions regarding MS SQL Server and data warehousing. What are warehouse modeling methods that could be used before creating data warehouse in MS SQL Server? How can ETL processes be automized using SQL Server Integration Services? Any feedback is appreciated. Thanks in advance!
