Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 14 Aug 2007 @ 16:44:37 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   How to build the normalized funtionality in Mload
 
From:   Anomy Anom

<-- Anonymously Posted: Monday, August 13, 2007 14:26 -->

Hi,

I have one scenario in MLOAD. pls find the following sample data

     10023879|20070405|5689~5269~2154~1026|Roxy shan bill

Above data have following seq..

     Customer identifier
     Transaction date
     Invoice numbers
     Customer name (FN LN MN)

Regular data have '|' delimited and invoice number column need to normalized with PK. invoice number column have '~' delimited.

i.e. the output of MLOAD should be like:

     10023879|20070405|5689|Roxy shan bill
     10023879|20070405|5269|Roxy shan bill
     10023879|20070405|2154|Roxy shan bill
     10023879|20070405|1026|Roxy shan bill

Appreciate for your time and solution.

Regards



     
  <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