Tags for extract
SQL for last 52 Weeks
Hello, I am tyring to write a query that will give me the customer counts on a rolling 52 week ending on monthly basis. I can't seem to find anything anywhere that will help me. I am trying to avoid pulling the query 12 times to get the 52 week customer counts ending for each month!   this is what I have so far:
sql teradata rolling counts extract ADD_MONTHS
XMLSEQUENCE and parsing name value pairs of XML data
Oracle has XMLSEQUENCE and Extract functions to parse XMLDATATYPE in to NAME VALUE pairs. I would like to do this in Teradata. IS there a similar function in Teradata? example from Oracle.  v_counter :=1;        
xmlsequence extract xmltype
Teradata Parallel Transporter User Guide 13.10
This book provides information on how to use Teradata Parallel Transporter (Teradata PT), an object-oriented client application that provides scalable, high-speed, parallel data extraction, loading, and updating. These capabilities can be extended with customizations or third-party products.
load etl tpt fastload multiload teradata parallel transporter fastexport tpump operator directory scan extract tpt-api transform v_tools
Teradata Parallel Transporter API Programmer Guide 13.10
This book provides information on how to use the Teradata Parallel Transporter (Teradata PT) Application Programming Interface. There are instructions on how to set up the interface, adding checkpoint and restart, error reporting, and code examples.
load etl tpt teradata fastload multiload fastexport tpump operator directory scan extract parallel tpt-api transform transporter v_tools
Teradata Parallel Transporter Reference 13.10
This book provides reference information about the components of Teradata Parallel Transporter (Teradata PT), an object-oriented client application that provides scalable, high-speed, parallel data extraction, loading, and updating. These capabilities can be extended with customizations or with third-party products.
load etl tpt teradata fastload multiload fastexport tpump operator directory scan extract parallel tpt-api transform transporter v_tools
Teradata Parallel Transporter Reference 13.0
This book provides reference information about the components of Teradata Parallel Transporter (Teradata PT), an object-oriented client application that provides scalable, high-speed, parallel data extraction, loading, and updating. These capabilities can be extended with customizations or with third-party products.
load etl tpt teradata fastload multiload fastexport tpump operator directory scan extract parallel tpt-api transform transporter