I need to know what are the methods that we can add new columns to the fact table and dimension tables to the data warehouse after the SSIS solution deploying to the database.
I have deveoped the datawarehouse using SSIS. Datawarehouse has been built using microsoft dynamics gp ERP data. For the datawarehouse, I have only extracted and loaded some required columns to the fact and dimension table. If i have to add another column after i deploy this project to the database what are the methods. Will there be NULL values after adding new columns to the fact and dimension tables.

Currently, I add the new column and do the initial load again and aganin when i add a new column.