Blogs
Oracle Segment Shrink Space feature for Reclaiming unused space
Introduction: Oracle Segment Shrink Space feature was introduced from Oracle database version 10g. It is used for...
Informatica jobs failure with connection timeout error
Subject: Informatica jobs fail with connection timeout error when Netezza database used as Source. Issue Details:...
How to find out schema name in Cognos Report Studio Report
Please find the below steps to find out the Schema name of the Query Subject or Report Item: Open report with report...
Slowly Changing Dimensions (SCD) in Datawarehouse
Dimensions that change slowly over time, rather than changing on a regular schedule, time-based. In Data Warehouse...
Oracle In-Memory Database
Introduction: The In-Memory Column Store (IM column store) allows users to store Oracle Database objects like columns,...
Configuring ODBC connection: Informatica with Redshift
Create a cluster in AWSDownload and install one of the following, depending on the system architecture of your SQL...
AWS: EBS at a Glance
Elastic Block Store- EBS Volume Types 4 volume types SSD – Solid State Drive HDD – Hard Disk Drive General Purpose –...
Mapping Creation in Informatica PowerCenter
Source Analyzer: Go to tools menu >select Source Analyzer as shown in below screenshot. Go to sources (from menu...
FileMaker Pro
Introduction FileMaker Pro is a cross-platform relational database application from FileMaker Inc., a subsidiary of...
How to get forgot Weblogic admin password
If we don’t remember WebLogic admin password, we can get it using the below method. [applmgr@ebsapp1 ~]$ sh...
Oracle Database Setup/Configuration Issues and Resolutions
1) Error No: INS-30131 Initial Setup for Oracle 12C in Windows 10 While performing setup of DB, we may face...
TypeScript error in Visual Studio
While trying to build the angular app in visual studio, I have noticed below errors. Error Details:- TS1219 –...