SharePointCommunity

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

Anmelden | Beitreten | Hilfe

SharePoint Mirror » Alle Tags » ETL (RSS)

Nach Markierungen suchen

Blogs

SharePoint Mirror

Home

Syndication

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

Archives

Using Temporary Tables for Complex Reports

Global temporary tables (or private temporary tables, if you use Oracle 18c) are a practical feature to be used for SQL queries with multiple steps, for example complex reports in a data warehouse. If you want to use them, some … Continue reading...

Veröffentlicht 15 Mai 2018 23:40 von triBLOG

Gespeichert unter: SQL, Oracle, Performance, ETL, DWH Architecture
Direct-Path INSERT and NOLOGGING with Oracle 12.2

Direct-Path INSERT is a very efficient way to load data into data warehouse tables. The load performance can even be improved with NOLOGGING on the target table. In Oracle 12c Release 2, this is even possible for Oracle Data Guard … Continue reading...

Veröffentlicht 20 Feb 2018 10:49 von triBLOG

Gespeichert unter: SQL, Oracle, Performance, ETL, Oracle 12c
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
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
Delta Detection in Oracle SQL

Delta detection is a common task in every Data Warehouse. It compares new data from a source system with the last versions in the Data Warehouse to find out whether a new version has to be created. There are several … Continue reading →.....

Veröffentlicht 8 Okt 2016 23:05 von triBLOG

Gespeichert unter: SQL, Oracle, ETL
Logging Dynamic SQL

Dynamic SQL is a wonderful feature with a lot of flexibility. Unfortunately, it is not trivial to see the executed SQL statements. A simple trick helps to test and debug PL/SQL code with Dynamic SQL. There are many situations in … Continue reading...

Veröffentlicht 25 Jan 2016 22:23 von triBLOG

Gespeichert unter: SQL, Oracle, ETL, PL/SQL, DWH Automation
Online Statistics Gathering in Oracle 12c

Since Oracle 12c, table statistics are gathered automatically for some bulk operations. This inconspicuous new feature called “Online Statistics Gathering for Bulk Loads” is very practical for ETL jobs in Data Warehouses. I remember an interesting...

Veröffentlicht 23 Dez 2015 13:34 von triBLOG

Gespeichert unter: SQL, Oracle, Performance, ETL, Oracle 12c
Foreign Key Constraints in an Oracle Data Warehouse

Foreign key constraints are often omitted in Data Warehouses. This blog post explains why this is not a good approach and what is a practical compromise for foreign key constraints in an Oracle Data Warehouse. In one of the sessions … Continue reading...

Veröffentlicht 1 Dez 2015 13:22 von triBLOG

Gespeichert unter: SQL, Oracle, Performance, ETL, Materialized Views
Loading Dimensions from a Data Vault Model

Loading data into a Data Vault Model is easy. But how complex is it to extract the data from a Data Vault into a dimensional Data Mart? A Point in Time (PIT) table helps to load Dimensions from a Hub … Continue reading →...( read more ) Mehr...

Veröffentlicht 12 Nov 2015 19:08 von triBLOG

Gespeichert unter: SQL, ETL, Dimensional Modeling, Data Vault Modeling
The End of Oracle Warehouse Builder – How to Migrate Existing OWB Projects

Oracle Warehouse Builder (OWB) is at the end of its lifecycle. The ETL tool will not be supported by Oracle in the future. But many customers have built data warehouses with OWB. What can they do with their existing OWB … Continue reading →...

Veröffentlicht 21 Jul 2015 11:31 von triBLOG

Gespeichert unter: Oracle, ETL, PL/SQL, Oracle Warehouse Builder, Oracle Data Integrator, DWH Automation
Avoid dbms_stats.auto_invalidate in ETL jobs

Recently I realized that the dbms_stats parameter no_invalidate is important for statistics gathering in ETL jobs. I never considered this parameter because “the default value will be good enough” – as for most other parameters of the...

Veröffentlicht 6 Jan 2015 0:11 von triBLOG

Gespeichert unter: Oracle, Performance, ETL
External Tables and Privileges

A typical use case in a Data Warehouse is that flat files are loaded into the Staging Area via external tables. The ETL process reads the contents of the file with a SELECT statement on an external table and writes it to the corresponding stage table...

Veröffentlicht 26 Jun 2014 0:28 von triBLOG

Gespeichert unter: Oracle, ETL
Oracle Warehouse Builder on an Oracle 12c Database

Oracle Database 12c Release 1 is available since a few hours. One important question for many data warehouse and ETL developers is: What happens to Oracle Warehouse Builder (OWB)? As mentioned earlier in this blog and described in Oracle's Statement...

Veröffentlicht 25 Jun 2013 23:17 von triBLOG

Gespeichert unter: Oracle, ETL, Oracle Warehouse Builder
Dynamischer OWB

Oft sind es kleine, ehr alltägliche Aufgaben, für die man beim OWB dann die Lösung sucht. Irgendwie hat man das meistens schon einmal gemacht, aber nun kommt man gerade nicht mehr drauf. Wie ging das noch mal? Oft sind die Antworten auch mit Google nicht...

Veröffentlicht 28 Jun 2012 11:45 von triBLOG

Gespeichert unter: TrivadisContent, OWB, 11g, ETL, dynamisch
Partition Exchange and Interval Partitioning

Last week I got an interesting question from a former colleague: How can interval partitioning in Oracle 11g be combined with partition exchange? With interval partitioning, it is not possible to create a new partition manually. Usually, this is what...

Veröffentlicht 1 Mai 2012 22:05 von triBLOG

Gespeichert unter: Oracle, ETL, PL/SQL, Partitioning

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

Using Temporary Tables for Complex Reports

Direct-Path INSERT and NOLOGGING with Oracle 12.2

10 Tips to Improve ETL Performance

Partition Exchange in Oracle 12.2

Delta Detection in Oracle SQL

Logging Dynamic SQL

Online Statistics Gathering in Oracle 12c

Foreign Key Constraints in an Oracle Data Warehouse

Loading Dimensions from a Data Vault Model

The End of Oracle Warehouse Builder – How to Migrate Existing OWB Projects

Avoid dbms_stats.auto_invalidate in ETL jobs

External Tables and Privileges

Oracle Warehouse Builder on an Oracle 12c Database

Dynamischer OWB

Partition Exchange and Interval Partitioning