TALEND SCD1 IMPLEMNATATION ....................

Source Table Data:-
 Emp_Id;Emp_Name;Emp_sal;Deptno
1640;Lyndon;6843;20
1671;Bill;6550;10
1756;Dwight;7978;10
1589;Benjamin;6189;20
1805;Grover;8000;10
1551;Harry;5600;20
1533;Lyndon;5700;10
1866;Millard;1726;30
1672;Woodrow;5589;10
1845;Jimmy;153;30

SCD1:-

Usecase:- target table maintain current infromation only...

Example:-

emp_id   emp_name  ,emp_sal  deptno etl_load_date
1640        Lyndon         6843        20         20/05/2019   ----------->target Record

after Few Days Their Change in sal example the hike sal  7500 give the employee

emp_id   emp_name  ,emp_sal  deptno etl_load_date
1640        Lyndon         7500        20         20/05/2019   ----------->target Record

No History Maintain in this table only maintain current data...

in talend :-

 soource---->tmap--------->insertflow & update flow

Job Degin:-



After Tmap  Logic:-




InsertDbSettings:-


UpdateDb Settings:-


Final Run It :-