Learn ETL with Examples
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, utilities related – Fastload, Multiload, … Read More
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 which may help you if … Read More
In the previous post, we created few tables in Redshift and in this post we will see how to load data present in S3 into these tables. To load data … Read More
In this post, we will see a very simple example in which we will create a Redshift table with basic structure and then we will see what all additional properties … Read More
It’s been few years since I have been working on HIVE, Impala, Spark SQL, PySpark, Redshift and in the journey so far I have migrated many applications in different RDBMS … Read More
While calculating measures you may want to convert seconds to TIME. Say you want to know how many HOURS,MINUTES & Seconds constitute this number. Example you may want to convert … Read More
If writing a typical TPT script is tedious task for you then you may try using existing TPT templates to quickly write a TPT script. Teradata provides list of templates … Read More
Recently someone in my team asked me how to fetch column list along with datatype from VIEW definition via jdbc connection. I proposed couple of solutions to him however due … Read More
“An owner referenced by user does not have SELECT WITH GRANT OPTION access to DB_Name.Table_Name.Col_Name “. This is very common error related with privileges granted to objects in Teradata. So … Read More
In most of the Teradata environment I have seen the preferred medium to call BTEQ is shell script. It means that Teradata developer will write a shell script which will … Read More
