SCD Type -1|| SQL Interview Questions || SQL

CREATE TABLE stage.dim_customer (
customer_id INT ,
name VARCHAR(100),
city VARCHAR(255),
m_status varchar(255)
--------------
CREATE TABLE dbo.dim_customer (
customer_id INT ,
name VARCHAR(100),
city VARCHAR(255),
m_status varchar(255)
);

insert into dbo.dim_customer
values(1,'siva','Hyderabad','Married'),(2,'pavan','vizag','unmarried'),(3,'kumar','Tirupati','unmarried')

insert into stage.dim_customer
values(4,'murali','Hyderabad','Married'),(2,'pavan','vizag','Married'),(3,'kumar','Guntur','unmarried')

merge dbo.dim_customer as target
using stage.dim_customer as source
on target.customer_id=source.customer_id
when matched then
update set name=source.name,
city=source.city,
m_status=source.m_status
when not matched
then insert (customer_id,name,city,m_status)
values(source.customer_id,source.name,source.city,source.m_status);