DataStages_Real_Time _Scenarios_ with Screen Shots_and _Solution

Wednesday, June 11, 2014

8.5 How to remove duplicate record using transformer stage?


 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