In the ETL world, it is always a need for processing the delimited files. While reading a delimited file can be done through all the scripts and programming languages, we will see how this can be done in a shell script using the cut command Syntax cut -d “|” => This is to tell the… Read More »
Command line arguments are essential for any programming or scripting language to have a control of the the input parameters. Passing arguments to the shell script can be done in multiple ways. In this blog, we will see the two ways of passing arguments to a shell script Option 1 – Using getops This method… Read More »
We often need the email facility in the shell script as most of the batch jobs in production are running in Linux based machines only. In case of issues, the jobs or scheduler needs to send failure notifications to the support DL. At times we may need the failure log as an attachment in the… Read More »
We can delete the first line in a file using ‘sed’ command in the shell script. Let us see with the help of a test file called ‘sample.txt’. Here are the contents of the text file. Option 1: Delete and save in a new file In this option, a new file will be created with… Read More »
Basic TEradata Query utility is one of the advantages of Teradata over other extraction utilities. The advantage of the BTEQ utility is its error handling ability and conditional execution. It is more common that the query execution is often compared against the conditional flow in programming languages and programmers may end up choosing JDBC connection… Read More »
Data structures are broadly classified into primitive and non-primitive data structures. The non-primitive data structure is further classified into linear and non-linear data structures. Primitive Data Structures Primitive data types or structures are predefined data types. They are supported by all programming languages. Examples are, Integer (int) – It is used to store the whole… Read More »
Batch Teradata Query(BTEQ) is a powerful utility in Teradata with multiple options. You can export/import tables and files and make use of them in the same sessions for checking conditions to take decisions. Based on the checks, you can perform your DDL, DML operations. In this post, we will use a very simple use case… Read More »
Definition Data Structures are a way of collecting and organizing data in a memory and we can perform operations in an effective manner. Why we need data structures? The main purpose is used to organize and manage the data efficiently. In the programming world, an organized way of storing and retrieving data will improve the… Read More »
In this post, I will explain JSON built in functions in SQL server to work with JSON string. The JSON built in functions introduced in SQL Server 2016 are, OPENJSON ISJSON JSON_VALUE JSON_QUERY JSON_MODIFY In the previous post, I explained OPENJSON function in detail with examples. Now, I will explain rest of the functions with… Read More »
In the other post, we saw how to create tables in Teradata and the corresponding examples for each. Here we will see how to create a table with select from another table. In this post, we will see how we can create a table using select in Teradata. There are different ways in which we… Read More »