How to remove duplicate record using transformer stage?
-------->First of all data should be sorted before processing into Xtf Stage
--------> use two stage variables, sv1,sv2
--------> first variable do the comparison ex: sv1 = sv2
--------->Secound variable to store the key valueis..whatever the value u need to be set for duplicate values
--------> ex-- > sv2 = column values(empid,deptno) anything as per business need
please follow below snapshots for more clarification
Thanks & Regards
Siva
No comments:
Post a Comment