How to Create or Drop the Secondary Index in Teradata
Secondary index in Teradata Secondary index is an alternate path to the rows of a table in Teradata. It is
Continue readingCategory: Teradata
Extract function in Teradata with examples
Extract function in Teradata EXTRACT function is used to get the Year,Month or Day from a date. Also it is
Continue readingConcatenation operator and Concat function in Teradata with examples
Teradata allows us to concatenate the string or numeric values using either concatenation operator or concat() function. Concatenation operator (||)
Continue readingHow to write nested Case statement in Teradata?
Case Statement in Teradata CASE statement is a conditional expression that used to evaluate the conditions or perform the equality
Continue readingJSON data type in Teradata with examples
What is JSON? Javascript Object Notation (JSON) is a text based data format for representing structured data based on Javascript
Continue readingHow to fetch the data from Teradata using Python pandas
Teradata module for Python Teradata module enables Python applications to connect to the Teradata Database, and interoperates with Teradata Database
Continue readingHow to resolve the numeric overflow error in Teradata
Numeric Datatypes in Teradata Teradata provides the multiple numeric data types for the columns and it is listed below Byte
Continue readingHow to add months or days to date in Teradata using Add_months and Interval function
ADD_MONTHS in Teradata Add_Months is a function that used to add or subtract months to date in Teradata. The output
Continue readingMerge or Upsert statement in Teradata with examples
Merge Statement in Teradata Merge statement is also referred as Upsert that inserts a record to a table in a
Continue readingHow to export the table to a file using BTEQ script in Teradata
EXPORT command in Teradata Export command is used to store the database information that returned by SQL Select statement in
Continue reading