PGP Encryption and Decryption

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 exchange sensitive data, such as payment details, employee information and so on over the internet use PGP encryption / decryption to transfer files...
Delete Truncate Drop Syntaxes Differences

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 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...
Cognos User Groups

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 click on Cognos Administration> Security Click on User Groups and Roles Click on the Cognos folder where we need to Create the User Group as shown...
Five Ways to Resolve Data Quality Problems in Tableau

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 monitoring helps to resolve data issues quickly and also provides quality data. There are various ways we can resolve data issues in Tableau without...
Splitting String in Informatica with Delimiter

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 source data from Database. Target: Step 2: Go to tools menu select target menu select target files from target menu. Import Target data from file (.csv...