SharePointCommunity

Die deutschsprachige Community für SharePoint, Office 365 und mit Azure

Anmelden | Beitreten | Hilfe

SharePoint Mirror » Alle Tags » Oracle (RSS)

Nach Markierungen suchen

Blogs

SharePoint Mirror

Home

Syndication

RSS
Atom
Kommentar-RSS
E-Mail-Aktualisierungen empfangen
Abonnieren

Archives

Debugging SCD2

Dieser Beitrag ist wieder über Slowly Changing Dimensions Type 2, betrachtet aber eine andere Fragestellung. Wie kann man die Erkennung der Änderungen validieren? Wenn wir mehrere Versionen derselben Daten haben, wie kann man prüfen, welche Felder sich...

Veröffentlicht 19 Aug 2017 18:34 von triBLOG

Gespeichert unter: SQL, Oracle, Allgemein, TrivadisContent, Trivadis, Data Warehouse, SCD2, Deltaerkennung, Historisierung, UNPIVOT
10 Tips to Improve ETL Performance

In summer time, the nights are very short. For some Data Warehouses, this is the case all year round, but not because of late sunset and early sunrise. The night is not long enough to finish all the ETL jobs. … Continue reading →...( read...

Veröffentlicht 23 Jul 2017 23:01 von triBLOG

Gespeichert unter: SQL, Oracle, Performance, ETL
Trivadis Performance Days 2017

On 13 and 14 September 2017, the Trivadis Performance Days 2017 will take place in Zurich. As in previous years, it will be an exciting event for everybody interested in Oracle performance features. For me, it will be a very … Continue reading →...

Veröffentlicht 13 Jul 2017 0:10 von triBLOG

Gespeichert unter: Oracle
Analytic Views: Powerful Oracle 12.2 Feature for Business Intelligence

Analytic Views are one of the main features for Business Intelligence introduced with Oracle 12c Release 2. They provide a lot of new possibilities for analytical queries on star schemas. This blog post gives an overview of the new functionality. In …...

Veröffentlicht 29 Jun 2017 0:01 von triBLOG

Gespeichert unter: SQL, Oracle, Oracle 12c, Dimensional Modeling
Attribute Dimensions and Hierarchies in Oracle 12c

Oracle 12c Release 2 introduced Analytic Views, a new set of metadata objects that are very useful for Data Warehouses and Business Intelligence applications. In the first blog post about this new feature I will have a detailed look at two … Continue...

Veröffentlicht 31 Mai 2017 16:23 von triBLOG

Gespeichert unter: SQL, Oracle, Oracle 12c, Dimensional Modeling
Get Ready for Oracle 12.2

The Oracle 12.2 grammar is now supported in the most current versions of PL/SQL Cop, PL/SQL Cop for SQL Developer, PL/SQL Cop for SonarQube and PL/SQL Analyzer. […] ...read more...( read more ) Mehr…

Veröffentlicht 14 Mai 2017 18:26 von triBLOG

Gespeichert unter: Oracle, PL/SQL, PL/SQL Developer, PL/SQL Cop, SonarQube, PL/SQL Analyzer, Oracle 12cR2
Datenhistorisierung II

Im vorherigen Post habe ich die Möglichkeit gezeigt, wie man eine Kombination aus UNION ALL und GROUP BY nutzen kann, um die Daten als Slowly Changing Dimension Type 2 zu historisieren. Seitdem habe ich einige Performance-Tests durchgeführt, um diesen...

Veröffentlicht 30 Apr 2017 12:56 von triBLOG

Gespeichert unter: Oracle, Allgemein, Trivadis, OWB, Data Warehouse, SCD2, slowly changing dimensions, Deltaerkennung, Historisierung
Derived Measures and Virtual Columns

Virtual Columns in Oracle are a convenient feature to implement derived measures of a fact table. But in combination with Oracle Database In-Memory, it has an impact on performance – unless you use Oracle 12c Release 2. Derived measures in …...

Veröffentlicht 10 Apr 2017 14:49 von triBLOG

Gespeichert unter: SQL, Oracle, Performance, Oracle 12c, in-memory, Dimensional Modeling
plscope-utils – Utilities for PL/Scope in Oracle Database 12.2

PL/Scope was introduced with Oracle Database version 11.1 and covered PL/SQL only. SQL statements such as SELECT, INSERT, UPDATE, DELETE and MERGE were simply ignored. Analysing […] ...read more...( read more ) Mehr…

Veröffentlicht 17 Mrz 2017 21:14 von triBLOG

Gespeichert unter: Oracle, PL/SQL, Dependency Analysis, Oracle 12cR2, PL/Scope
Real-Time SQL Monitoring Report History in 12c

Subtitle: Performance Analysis with TaRTeSMon Hi there, In this blog post I want to write about Real-Time SQL monitoring enhancements of 12c and I do this almost simultaneously to my speeches about that topic. One is at the Trivadis internal Techevent...

Veröffentlicht 17 Mrz 2017 11:37 von triBLOG

Gespeichert unter: Oracle, Licensing, Real-Time SQL Monitoring, TaRTesMon
Partition Exchange in Oracle 12.2

There are many new extensions for Partitioning in Oracle 12c Release 2 (12.2). One of them is the CREATE TABLE FOR EXCHANGE statement. Some years ago, I wished to have this feature for a particular problem with hidden columns. Column … Continue...

Veröffentlicht 9 Feb 2017 16:13 von triBLOG

Gespeichert unter: SQL, Oracle, ETL, Partitioning, Oracle 12c
PL/SQL Cop for Trivadis PL/SQL & SQL Coding Guidelines Version 3.2

The PL/SQL Cop tool suite supports the new Trivadis PL/SQL & SQL Coding Guidelines 3.2. Download the new versions from the Download section. So, what’s new? Numbering and Categorisation Scheme The guidelines have been renumbered, extended, categorised…...

Veröffentlicht 6 Feb 2017 2:34 von triBLOG

Gespeichert unter: Oracle
How to Build Hash Keys in Oracle

Hash keys can be used instead of sequence numbers to build surrogate keys in a Data Warehouse. This is often done in Data Vault environments, and there are some good reasons to do that. But there are also several issues … Continue reading →...

Veröffentlicht 24 Jan 2017 0:51 von triBLOG

Gespeichert unter: Oracle
ANSI Join Syntax and Query Rewrite

There are many good reasons to use ANSI join syntax instead of the old Oracle join syntax. With one exception: If you want to use your Materialized Views for Query Rewrite, avoid to write them with ANSI joins. I’m a … Continue reading →.....

Veröffentlicht 30 Nov 2016 11:11 von triBLOG

Gespeichert unter: SQL, Oracle, Performance, Materialized Views
Wie vereinfache ich die Historisierung der Daten?

Die Historisierung der Daten ist eine typische aber auch rechen- und zeitintensive Aufgabe im Data Warehouse Umfeld. Man hat damit beim Beladen von historisierter Core-Schicht (auch bekannt als Enterprise Data Warehouse or Foundation Layer), Data Vault...

Veröffentlicht 24 Nov 2016 17:39 von triBLOG

Gespeichert unter: SQL, Oracle, Allgemein, Trivadis, OWB, Data Warehouse, SCD2, slowly changing dimensions, Deltaerkennung, Historisierung

1 2 3 4 5 Weiter > ... Letzte »

CC BY-NC-ND - Michael Greth

Mit Community Server (Commercial Edition), von Telligent Systems

3DZL:andrewbelon.com

Datenschutzerklärung

Nach Markierungen suchen

Blogs

Sponsored by

Syndication

Recent Posts

Tags

Archives

Debugging SCD2

10 Tips to Improve ETL Performance

Trivadis Performance Days 2017

Analytic Views: Powerful Oracle 12.2 Feature for Business Intelligence

Attribute Dimensions and Hierarchies in Oracle 12c

Get Ready for Oracle 12.2

Datenhistorisierung II

Derived Measures and Virtual Columns

plscope-utils – Utilities for PL/Scope in Oracle Database 12.2

Real-Time SQL Monitoring Report History in 12c

Partition Exchange in Oracle 12.2

PL/SQL Cop for Trivadis PL/SQL & SQL Coding Guidelines Version 3.2

How to Build Hash Keys in Oracle

ANSI Join Syntax and Query Rewrite

Wie vereinfache ich die Historisierung der Daten?