Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 12 Dec 2000 @ 22:49:14 GMT


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


Subj:   M-Load for Cross-Tab table
 
From:   Sudarsan Thopay

Hi all,

We have datafile in usual format.

     Acct_Nbr Prod_Id..
     Acct_Nbr Prod_Id..
     ................. ..............

It has hundreds of Prod_Id.

Using Multi-Load, Is there a way to load a table in Cross-Tab format. (i.e. The table with columns Acct_Nbr,Prod01,Prod02,Prod03 ....,Prodxxx). We would like to have one record for each account and a Y/N flag for the specific Prod_Id. Apparently the table is NOT normalized, it has hard-coded Prod_Ids as column names and a view on the normalized table could achieve the required result. But it is not quiet efficient to the business users for further analysis. Right Now we are using BTEQ/SQL to achieve this, which takes v.v.long time for the result.


Thanks

Sudarsan Thopay



     
  <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