DSXchange

Hi saravana cuold u give me idiathat how we can remov duplicate row using stage variable

IN CONSTRAINS I GIVINING THIS CONDITION Feed.HFEDU_ID <> LKPHash.HFEDU_ID FOR NEW DATA LOAD AND FOR OTHER REJECT ROW BUT FOR NOT EQUAL, I DON'T KNOW WHY THIS CONDITION IS NOT WORKING EVEN WHEN I AM GIVING Feed.HFEDU_ID = LKPHash.HFEDU_ID FOR REJECT ROW OR CAN SAY REJECT OLD ROW I AM GETTING PROPER R...

vmalviya, if your incoming source data is sorted upon the column(s) that you want to use to identify unique records then you can can declare stage variables in a transform that simply compare these to the last record, and if they match to constrain the output. Unsorted data is more difficult, in th...