Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 25 Feb 2014 @ 12:33:37 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Single Amp de-duplication
From:   David Clough

Hi ...

I'm converting a Stored Procedure from what contains multiple All Amp operations into a series of Single Amp operations.

Good progress so far, but one area remains problematic :

I receive a series of Country/Account value Pairs in through the Interface, in one long string. I then chop these up and Insert each Value Pair into a Temporary Table. ?Up until this new Single Amp change I was also de-duping the input string by ensuring that, were there to be any duplicate values in the string, I only take one of the duplicates.

Thing is, de-duping is an inherently All Amp type operation, it seems to me - no good for what I'm now doing.

The only other thought was to use a SET Table in order to avoid total duplicates, butthis only results in both of the duplicates being discarded.

Any thoughts on how to proceed ?

As a last resort I could get the invoking Java app to de-dup before Calling the Stored Procedure.


David Clough
Senior BI Database Designer
BI Competency Centre

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023