Blogs
Tableau Filters
The filters can be applied in a worksheet to restrict the number of records present in a dataset. Tableau provides the...
Oracle Multitenant Architecture
Introduction: From Oracle Database 12c release, Oracle introduced multitenant architecture. With this architecture,...
Oracle Data Guard and Active Data Guard
Introduction: To ensure data protection, high availability and disaster recovery for enterprise data, Oracle...
Subversion
Introduction: Subversion (SVN) is a centralized SCM (Software Configuration Management) implementation. It allows...
QlikView Server License Update
1. Backup Plan before license Update Before going ahead for license update activity, we need to take the backup for...
Difference between Rank and Dense_Rank Functions and Nth Highest salary
Rank (): RANK function is used to rank the repeating values in a manner such that similar values are ranked the same....
Datatypes and operators in Redshift
Redshift query basics: The maximum size for a single Amazon Redshift SQL statement is 16 MB Some Amazon Redshift...
PGP Encryption and Decryption
GnuPG is a GNU’s tool for secure communication and data storage and it’s a command line tool. Most companied that...
Delete Truncate Drop Syntaxes Differences
Truncate removes all the rows from a table. Delete with a where clause can delete rows (as specified using where...
Cognos User Groups
Creating the User Group and add the members to the User Group in Cognos Log on to the Cognos connection Go the launch...
Five Ways to Resolve Data Quality Problems in Tableau
Data sets are not static. They are constantly being updated, which can affect the quality of data. Data quality...
Splitting String in Informatica with Delimiter
Source Analyzer: Step 1: Go to tools menu select source menu select Source analyser files from source menu. Import...