How to run the BTEQ script in Teradata using Unix shell script
BTEQ(Batch TEradata Query) is the utility used in Teradata and It helps to execute the queries either batch or interactive
Continue readingFind the occurrence of each character in string using python
Method 1: Count function : The count function is used to count the occurrence of each character in string. Here
Continue readingBubble sort program in C using array with examples
There are many techniques to sort the values. Bubble sort is one of the sorting algorithm used to sort the
Continue readingParallel execution of SQL statements using Parallel hint in Oracle
Few of the queries takes more time to run in oracle due to large volume of data.We can enable the
Continue readinggrep command in Unix/Linux with examples
The grep command used to search the characters or lines for a particular format in the file and printing the
Continue readingNULLIFZERO in Teradata with examples
NULLIFZERO Function in Teradata NULLIFZERO is a one of the useful function in Teradata. It is used to validate the
Continue readingDifference between echo and echo -e in Shell script
echo: It is used to print the line of text which are given between the double quotes(“….”). Literally it just
Continue readingReplace a string in a column using oreplace and otranslate functions in Teradata
Sample Table name :Employee EmployeeId Name Location 123 Keven Newyork 456 david Chicago OREPLACE Function in Teradata The OREPLACE function
Continue readingHow to check if the file or directory exists in HDFS?
Hadoop command to check whether the directory exists or not: Syntax: hdfs dfs -test -d hdfs_path Example: hdfs dfs -test
Continue readingC program to display the Fibonacci Series
Explanation The Fibonacci series are integer sequence of 0,1,1,2,3,5,8…..The first two numbers in the series are 0 and 1.The subsequent
Continue reading