by ablessquare | Jul 31, 2019 | Blogs
1. Backup Plan before license Update Before going ahead for license update activity, we need to take the backup for QlikView Server and documents. Basically, two types of backup will be taken. 1: QlikView server files backup. 2: QlikView Document’s shared files and...
by ablessquare | Jul 30, 2019 | Blogs
Rank (): RANK function is used to rank the repeating values in a manner such that similar values are ranked the same. In other words, rank function returns the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks...
by ablessquare | Jul 30, 2019 | Blogs
Redshift query basics: The maximum size for a single Amazon Redshift SQL statement is 16 MB Some Amazon Redshift queries are distributed and executed on the compute nodes, and other queries execute exclusively on the leader node The leader node distributes SQL to the...
by ablessquare | Jul 29, 2019 | Blogs
GnuPG is a GNU’s tool for secure communication and data storage and it’s a command line tool. Most companied that exchange sensitive data, such as payment details, employee information and so on over the internet use PGP encryption / decryption to transfer files...
by ablessquare | Jul 26, 2019 | Blogs
Truncate removes all the rows from a table. Delete with a where clause can delete rows (as specified using where clause) from a table. Drop will delete a table from the database. Drop and Truncate are DDL commands, whereas DELETE is a DML command. Please find the...
