Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 15 Mar 2016 @ 20:34:47 GMT


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


Subj:   Reduce export time using tpt
 
From:   Ganga, Sandeep Kumar

Hi Forum,

Performing the tpt export , ?table data to a csv file.

I am looking forward for responses on to reduce the tpt export time.

I am using below script and the data size is about 2GB and is taking 40mins to me.

     DEFINE JOB EXPORT_DELIMITED_FILE_1
     DESCRIPTION 'Export rows from a date_dim'
     (
     DEFINE SCHEMA PRODUCT_SOURCE_SCHEMA
     (
     date_key     VARCHAR(10),
     month_name   VARCHAR(20)
     );
     DEFINE OPERATOR SQL_SELECTOR
     TYPE SELECTOR
     SCHEMA PRODUCT_SOURCE_SCHEMA
     ATTRIBUTES
     (
     Integer Minsessions=3,
     Integer Maxsessions=8,
     VARCHAR PrivateLogName = 'selector_log',
     VARCHAR TdpId = '',
     VARCHAR UserName = 'sandeep',
     VARCHAR UserPassword = '',
     VARCHAR SelectStmt = 'select  date_key,month_name from sandeep.empdata',
     VARCHAR ReportModeOn='Yes'
     );
     DEFINE OPERATOR FILE_WRITER
     TYPE DATACONNECTOR CONSUMER
     SCHEMA *
     ATTRIBUTES
     (
     VARCHAR PrivateLogName = 'dataconnector_log',
     VARCHAR DirectoryPath = 'C:/Users/sandeepganga/Desktop/',
     VARCHAR FileName = 'date_dim_2.csv',
     VARCHAR Format = 'DELIMITED',
     VARCHAR OpenMode = 'Write',
     VARCHAR TextDelimiter = '|',
     VARCHAR TRACELEVEL='ALL'
     );
     APPLY TO OPERATOR (FILE_WRITER)

     SELECT * FROM OPERATOR (SQL_SELECTOR);
     );

BR,

Sandeep.

GANGA SANDEEP KUMAR



     
  <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