How to schedule tasks on Linux using crontab
Cron in Linux Cron is a time-based job scheduler in Linux or Unix operation system. It is most suitable for
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 run program in background mode and run it after we logoff Linux system?
Nohup command in Linux nohup command is used to execute long running programs in background mode. Even if we logoff
Continue readingHow to create the new database in Sqlite using Python
SQLite in Python SQLite is a lightweight disk-based storage that doesn’t require separate server process in python.Some application can use
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 readingHow to split the string based on pattern in Hive
Split function in Hive Hive providing many string functions to manipulate the strings. Split is one of the string function
Continue readingHow to rename a table in Teradata?
Teradata Rename Table We can rename the existing Teradata table using RENAME TABLE statement.We should have DROP privileges on the
Continue readingHow to append Timestamp to file name in Shell script
Create log file with current timestamp in Bash It is best practice to have log file in any shell script
Continue readingHow to start and stop the Apache tomcat server in command line
Apache Tomcat Server Apache tomcat server is a open source web server that is developed by Apache software foundation. It
Continue readingConditional execution of SQL statements using activity count in Teradata BTEQ
ACTIVITY_COUNT in Teradata Activity count is a variable that returns the number of rows affected by the SQL statement in
Continue reading