SCD TYPE 2-DATE METHOD IN IICS/IDMC -INFORMATICA

Описание к видео SCD TYPE 2-DATE METHOD IN IICS/IDMC -INFORMATICA

SRC_TABLE

CREATE TABLE s1_scd_type2_date (
customer_id NUMBER(20) PRIMARY KEY,
first_name VARCHAR2(25),
mobile NUMBER(20),
address VARCHAR2(25),
zipcode NUMBER(25),
country VARCHAR2(25)
);

TGT_TABLE

CREATE TABLE T_scd_type2_date (
customer_key NUMBER(20) PRIMARY KEY,
customer_id NUMBER(20),
first_name VARCHAR2(25),
mobile NUMBER(20),
address VARCHAR2(25),
zipcode NUMBER(25),
country VARCHAR2(25),
Eff_date DATE,
End_date DATE
);

Комментарии

Информация по комментариям в разработке