I have some 15 tables and using data of that 15 tables I have created a view by using left join of each table column with another table column which matches the data type
2) using view I got Headcount and exit count of that table
now scenario is I have to run ssis package daily to updated and inserted records (incremental loading) in that view by using the base table and reference table data.
what will be the process of source and how I can compare whether records updating or inserting of new records