Скачать с ютуб Brief Explanation of SCD Type 2 Implementation in IICS without using Lookup Transformation в хорошем качестве

Brief Explanation of SCD Type 2 Implementation in IICS without using Lookup Transformation

#iics #ipass #informatica A Short Video with Brief Explanation of SCD Type 2 Implementation in IICS ( Informatica Intelligent Cloud Services) without using Lookup Transformation Note: There is no basic concept covered in this video and this Video is for Advance learner. The one who is already expertise in IICS and SCD Type 2. Data for Practice ------------------------- CREATE TABLE SRC_EMPLOYEES (e_id number(10),e_name varchar(100),e_loc varchar(100)); ALTER TABLE SRC_EMPLOYEES ADD PRIMARY KEY(e_id); INFO src_employees; DESC SRC_EMPLOYEES; SELECT * FROM SRC_EMPLOYEES; INSERT INTO SRC_EMPLOYEES VALUES(101,'A','BNG'); INSERT INTO SRC_EMPLOYEES VALUES(102,'B','HYD'); INSERT INTO SRC_EMPLOYEES VALUES(103,'C','MUM'); INSERT INTO SRC_EMPLOYEES VALUES(104,'D','DEL'); COMMIT; CREATE TABLE TGT_EMPLOYEES(DK NUMBER(10) PRIMARY KEY,E_ID NUMBER(10),E_NAME VARCHAR(100),E_LOC VARCHAR(100),E_STARTDT DATE,E_ENDDT DATE); SELECT * FROM TGT_EMPLOYEES; DESC TGT_EMPLOYEES; --Testing SELECT * FROM SRC_EMPLOYEES; UPDATE SRC_EMPLOYEES SET E_LOC='KOL' WHERE E_ID=103; COMMIT; INSERT INTO SRC_EMPLOYEES VALUES(105,'E','MUM'); COMMIT; SELECT * FROM TGT_EMPLOYEES;