by ablessquare | Apr 22, 2019 | Blogs
Subject: Apache shutdown unexpectedly in XAMPP ERROR: [Apache] Status change detected: running[Apache] Status change detected: stopped[Apache] Error: Apache shutdown unexpectedly.[Apache] This may be due to a blocked port, missing dependencies.[Apache] improper...
by ablessquare | Apr 9, 2019 | Blogs
Introduction: Oracle Segment Shrink Space feature was introduced from Oracle database version 10g. It is used for reclaiming unused/fragmented space from database objects like table, index-organized table (IOT), index, partition, sub-partition, materialized view or...
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...