Effortlessly Loading a CSV File into Teradata using Python
Learn how to easily load a CSV file into a Teradata database using Python with minimal code. No need for complex scripts or ETL tools. Read more.
CSV
Teradata strtok_split_to_table, CSVLD, Unpack: Column Splitting in Teradata
Splitting column content can be a challenging task. Teradata provides multiple methods to achieve this, each with unique pros and cons. In this article, we will examine these techniques in detail. To begin, we will generate a table containing sufficient random data to assess every option’s efficiency and resource utilization. The Teradata “CSVLD” Function This …
Two Methods for Generating Number Ranges in Teradata
Method 1, avoiding any helper tables or functions which are only available in new releases of Teradata: Method 2, with helper tables and XMLAGG: Both methods deliver the string “1,2,3,4,5,6,7,8,9,10”. Which process do you believe is using fewer Disk IOs and CPU resources?