Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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.


Regards

David Clough
Senior BI Database Designer
BI Competency Centre



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