Skip to content

ETL with SQL

Learn ETL with Examples
  • Home
  • Teradata
    • Teradata String Functions
  • Teradata SQL Cheat Sheet
  • TD Import Script Generator
  • About
  • Privacy Policy

ETL with SQL

Learn ETL with Examples
  • Home
  • Teradata
    • Teradata String Functions
  • Teradata SQL Cheat Sheet
  • TD Import Script Generator
  • About
  • Privacy Policy
Redshift

Should you use PARQUET files with Redshift Copy ?

  • by Raj
  • October 20, 2020October 20, 2020
  • Redshift SQL

Amazon Redshift supports loading columnar file formats like PARQUET, ORC. This extends compatibility and possibility of moving data easily from different environments for your data… Read More »Should you use PARQUET files with Redshift Copy ?

Redshift

4 ways to Create Table in Redshift

  • by Raj
  • September 27, 2020October 30, 2020
  • Redshift SQL

In the previous post, we saw that you can create table in redshift by specifying 3 minimum details : Table Name, Column Name & Column… Read More »4 ways to Create Table in Redshift

teradata

Teradata concatenate – syntax and example

  • by Raj
  • September 19, 2020September 26, 2020
  • Teradata SQL

In Teradata, we can use concatenation operator to link multiple string or numeric or expression values into single value. Input for concatenate can be two… Read More »Teradata concatenate – syntax and example

teradata

Teradata Numeric overflow occurred during computation

  • by Raj
  • August 15, 2020September 12, 2020
  • Teradata SQL

Numeric overflow is a very common error in Teradata which you will encounter while handling numeric values in computation or transformation. The error comes when… Read More »Teradata Numeric overflow occurred during computation

teradata

50 Teradata Interview Questions & Answers

  • by Raj
  • July 1, 2020September 4, 2020
  • Teradata SQL

I am sharing below 50 Teradata Interview questions which covers various topics and shall help in preliminary rounds of Interview. It covers basic architecture questions,… Read More »50 Teradata Interview Questions & Answers

aws

My experience of AWS Certified Solutions Architect – Associate

  • by Raj
  • May 23, 2020
  • 2 Comments
  • Uncategorized

I recently appeared for AWS Certified Solutions Architect (Associate) exam and cleared it comfortably. I would like to share my experience and journey so far… Read More »My experience of AWS Certified Solutions Architect – Associate

  • 1
  • 2
  • 3
  • …
  • 21
  • Next »

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 213 other subscribers

Topics

  • Redshift SQL
  • Teradata SQL
  • Uncategorized
  • UNIX

Recent Posts

  • Should you use PARQUET files with Redshift Copy ?
  • 4 ways to Create Table in Redshift
  • Teradata concatenate – syntax and example
  • Teradata Numeric overflow occurred during computation
  • 50 Teradata Interview Questions & Answers
  • My experience of AWS Certified Solutions Architect – Associate
  • Redshift Copy Command – Load S3 Data into table
  • Redshift Create Table Example
  • Moving from Teradata to Hadoop – Read this before
  • Convert number to TIME in Teradata

What others are reading

  • Teradata Parallel Transporter TPT - Basics , Example and Syntax
  • Teradata SQL Cheat Sheet
  • How to pass parameters to BTEQ script
  • How to find and fix Invalid Date Error in Teradata
  • Should you use PARQUET files with Redshift Copy ?
  • Teradata Interval Field Overflow
  • Teradata Date Functions
  • Moving from Teradata to Hadoop - Read this before
  • Teradata TPT Export script
  • Check SQL history in Teradata
© 2020 etl-sql.com