Blogs
Amazon Redshift Query processing and Result caching
Introduction: In this document, we are going see the flow of query processing and result caching feature in Amazon...
Column Compression in Amazon Redshift
What Is Compression? Compression is a column-level operation that reduces the size of data when it is stored....
Edit Unknown or Ambiguous Locations in Tableau
Sometimes Tableau will not recognise one or more of the location names in your data. When this happens, those values...
HAProxy
Introduction: HAProxy, which stands for High Availability Proxy. Its most common use is to improve the performance and...
SQL Joins – SQL Joins and Types of Joins
JOINS: Join is used to combine one or more tables, from tables based on condition (Common fields). Joins are divided...
Creating Flat file with two Headers in Informatica PowerCenter
FLAT FILE: A flat file is an ASCII text file which is saved with extension .txt, .csv, etc… Source Analyzer: Step 1:...
Removing # at Header in Informatica PowerCenter
While creating flatfile with header line by using session level header command, by default it adds # symbol in header...
ADOP Issues
Adop Issues: Adop is not to able to detect any valid application tier node entries in the ADOP_VALID_NODES table this...
How to Increase the WordPress Upload File Size
Subject: The error occurs while uploading the Media or files into WordPress. Error: “exceeds the maximum upload size...
Deployment – Importing objects to Cognos connection
Importing The Content From The Environment: Copy the exported file from the Deployment folder of the other environment...
Amazon Redshift Backups
Snapshots are point-in-time backups of a cluster. There are two types of Snapshots: AUTOMATED and MANUAL. Redshift...
Massive Parallel Processing (MPP)
Introduction: Massive Parallel Processing (MPP) is a type of processing where the data and processing power are split...