Blogs
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...
AWS: S3 at a Glance
Simple Storage Service – S3  – Object-Based Storage  – Unlimited Storage  – Not Suitable to install OS and/or Database...
QMC rights to User in QlikView Application
How to grant QMC rights to a user in QlikView Remote Desktop to the server. Open the Start Menu and navigate to...
Export reports from one environment to another environment in Cognos
Log on to the Cognos connection. Launch IBC Cognos Administration Go to the configuration tab > Click on Content...
Apache shutdown unexpectedly
Subject: Apache shutdown unexpectedly in XAMPP ERROR: [Apache] Status change detected: running[Apache] Status change...