by ablessquare | Apr 1, 2019 | Blogs
Subject: Informatica jobs fail with connection timeout error when Netezza database used as Source. Issue Details: Informatica jobs failure with a connection timeout error. The below messages appear in the session log for a PC session using a Netezza bulk reader or...
by ablessquare | Mar 30, 2019 | Blogs
Please find the below steps to find out the Schema name of the Query Subject or Report Item: Open report with report studio Go to the Source Tab and select the Query subject or data item as shown in below screenshot Right click on the Query subject or data item to...
by ablessquare | Mar 29, 2019 | Blogs
Dimensions that change slowly over time, rather than changing on a regular schedule, time-based. In Data Warehouse there is a need to track changes in dimension attributes in order to report historical data. In other words, implementing one of the SCD types should...
by ablessquare | Mar 29, 2019 | Blogs
Introduction: The In-Memory Column Store (IM column store) allows users to store Oracle Database objects like columns, tables, partitions and materialized views in memory in a columnar format, rather than the typical row format. It is mainly used for analytic queries...
by ablessquare | Mar 27, 2019 | Blogs
Create a cluster in AWS Download and install one of the following, depending on the system architecture of your SQL client tool or application: 32-bit:https://s3.amazonaws.com/redshift-downloads/drivers/odbc/1.4.4.1001/AmazonRedshiftODBC32-1.4.4.1001.msi (The name for...
