IICS | Best Method To Remove Duplicates Records From Source in Informatica Cloud

Hi Friends in this video we will learn how to remove duplicate in database using sorter and aggregator function , this method can be used with any source flat file/oracle . This is Evergreen Method

#informatica #iics #informática #tutorial #etltesting #datawarehouse #sql

[ETLSTATION]

Hi Friends Thank you for watching my video . Please subscribe to my channel like it and share it with your friends .

also comment if you get any doubt on video, i will try to answer your doubt

[mardinliserseri]

Thanks for this informative and crucial tricks.

[ETLSTATION]

Hi Friends, Please Find the Create table script and data used in oracle and snowflake, change schema name and table name as per your database .


CREATE TABLE "SRC"."SRC_SAP"
( "EMP_ID" NUMBER(38, 0),
"EMP_NM" VARCHAR2(100 BYTE),
"STATUS" VARCHAR2(50 BYTE),
"SRC_CD" VARCHAR2(50 BYTE),
"CITY" VARCHAR2(100 BYTE),
"COUNTRY" VARCHAR2(100 BYTE),
"UPDATE_DT" DATE
);

Insert into SRC.SRC_SAP (EMP_ID, EMP_NM, STATUS, SRC_CD, CITY, COUNTRY, UPDATE_DT) values (10, 'RAM', 'A', 'SAP', 'DELHI', 'IN', to_date('01-JUN-23', 'DD-MON-RR'));
Insert into SRC.SRC_SAP (EMP_ID, EMP_NM, STATUS, SRC_CD, CITY, COUNTRY, UPDATE_DT) values (20, 'STEVE', 'A', 'SAP1', 'DALLAS', 'US', to_date('02-JUN-23', 'DD-MON-RR'));
Insert into SRC.SRC_SAP (EMP_ID, EMP_NM, STATUS, SRC_CD, CITY, COUNTRY, UPDATE_DT) values (30, 'ANGELA', 'A', 'SAP', 'NYC', 'MX', to_date('02-JUN-23', 'DD-MON-RR'));
Insert into SRC.SRC_SAP (EMP_ID, EMP_NM, STATUS, SRC_CD, CITY, COUNTRY, UPDATE_DT) values (40, 'RAVI', 'A', 'SAP', 'MUMBAI', 'IN', to_date('02-JUN-23', 'DD-MON-RR'));
Insert into SRC.SRC_SAP (EMP_ID, EMP_NM, STATUS, SRC_CD, CITY, COUNTRY, UPDATE_DT) values (10, 'RAM', 'A', 'ORACLE', 'PUNE', 'IN', to_date('16-JUN-23', 'DD-MON-RR'));

Snowflake Table create is same as oracle just schema name and table name change

[ManojThakur-wj]

SABKO SNOWFLAKE BATAKE KHUD KE BHI LALWE LAGA DO.