Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

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

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


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.


  <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