SharePointCommunity
Die deutschsprachige Community für SharePoint, Microsoft 365, Teams, Yammer und mit Azure
Anmelden
|
Beitreten
|
Hilfe
Home
Angebote
Blogs
Foren
Podcast
Youtube
Social
Wikis
ToolBox
Partner
UserGroups
Termine
Impressum
SharePointPodcast
M.Greth
@IntranetBabett
TechNet
Mirror
UserGroups
SharePoint Mirror
»
Alle Tags
»
ETL
(
RSS
)
Nach Markierungen suchen
Blogs
SharePoint Mirror
Home
Sponsored by
Partner
Syndication
RSS
Atom
Kommentar-RSS
E-Mail-Aktualisierungen empfangen
Abonnieren
Recent Posts
Materialized View Refresh for Dummies
Issue with the Hint ENABLE_PARALLEL_DML
Online Statistics Gathering for ETL – Part 3
10 Tips to Improve ETL Performance – Revised for ADWC
Gathering Statistics in the Autonomous Data Warehouse Cloud
Tags
Allgemein
Azure
Cloud
deutsch
Developer
Development
english
HowTo
Microsoft
MVP
News
Newsticker
next Generation Sync Client
Office 2010
Office 2013
Office 365
Office365
OneDrive
OneDrive for Business
SharePoint
SharePoint 2010
Sharepoint 2013
SharePoint Online
Ticker
Tipps
View more
Archives
Januar 2021 (8)
Dezember 2020 (16)
November 2020 (20)
Oktober 2020 (24)
September 2020 (26)
August 2020 (20)
Juli 2020 (39)
Juni 2020 (26)
Mai 2020 (32)
April 2020 (26)
März 2020 (42)
Februar 2020 (28)
Januar 2020 (34)
Dezember 2019 (38)
November 2019 (28)
Oktober 2019 (32)
September 2019 (40)
August 2019 (31)
Juli 2019 (45)
Juni 2019 (54)
Mai 2019 (60)
April 2019 (40)
März 2019 (65)
Februar 2019 (56)
Januar 2019 (68)
Dezember 2018 (43)
November 2018 (47)
Oktober 2018 (54)
September 2018 (41)
August 2018 (45)
Juli 2018 (60)
Juni 2018 (76)
Mai 2018 (84)
April 2018 (88)
März 2018 (83)
Februar 2018 (91)
Januar 2018 (113)
Dezember 2017 (95)
November 2017 (85)
Oktober 2017 (97)
September 2017 (121)
August 2017 (60)
Juli 2017 (101)
Juni 2017 (92)
Mai 2017 (92)
April 2017 (111)
März 2017 (130)
Februar 2017 (110)
Januar 2017 (101)
Dezember 2016 (113)
November 2016 (107)
Oktober 2016 (129)
September 2016 (108)
August 2016 (84)
Juli 2016 (87)
Juni 2016 (95)
Mai 2016 (139)
April 2016 (104)
März 2016 (106)
Februar 2016 (83)
Januar 2016 (98)
Dezember 2015 (96)
November 2015 (106)
Oktober 2015 (94)
September 2015 (71)
August 2015 (76)
Juli 2015 (93)
Juni 2015 (85)
Mai 2015 (98)
April 2015 (113)
März 2015 (103)
Februar 2015 (107)
Januar 2015 (107)
Dezember 2014 (96)
November 2014 (110)
Oktober 2014 (141)
September 2014 (146)
August 2014 (106)
Juli 2014 (136)
Juni 2014 (133)
Mai 2014 (129)
April 2014 (143)
März 2014 (195)
Februar 2014 (150)
Januar 2014 (143)
Dezember 2013 (144)
November 2013 (130)
Oktober 2013 (173)
September 2013 (140)
August 2013 (120)
Juli 2013 (148)
Juni 2013 (155)
Mai 2013 (148)
April 2013 (164)
März 2013 (155)
Februar 2013 (151)
Januar 2013 (209)
Dezember 2012 (182)
November 2012 (190)
Oktober 2012 (219)
September 2012 (164)
August 2012 (167)
Juli 2012 (203)
Juni 2012 (112)
Mai 2012 (144)
April 2012 (150)
März 2012 (163)
Februar 2012 (164)
Januar 2012 (112)
Dezember 2011 (158)
November 2011 (120)
Oktober 2011 (101)
September 2011 (93)
August 2011 (80)
Juli 2011 (102)
Juni 2011 (139)
Mai 2011 (124)
April 2011 (134)
März 2011 (179)
Februar 2011 (102)
Januar 2011 (86)
Dezember 2010 (85)
November 2010 (54)
Oktober 2010 (108)
September 2010 (108)
August 2010 (57)
Juli 2010 (84)
Juni 2010 (67)
Mai 2010 (68)
April 2010 (65)
März 2010 (55)
Februar 2010 (66)
Januar 2010 (64)
Dezember 2009 (52)
November 2009 (64)
Oktober 2009 (138)
September 2009 (59)
August 2009 (43)
Juli 2009 (35)
Juni 2009 (25)
Mai 2009 (32)
April 2009 (11)
März 2009 (6)
Februar 2009 (1)
Januar 2009 (7)
Dezember 2008 (1)
September 2008 (1)
Juni 2006 (1)
11g
12c
18c
ADWC
bulk insert
bulk load
CBO
Cloud
Data Vault Modeling
Data Warehouse
Dimensional Modeling
DWH Architecture
DWH Automation
dynamisch
incremental statistics
Materialized Views
Merge
on the fly
online statistics gathering
Oracle
Oracle 12c
Oracle 18c
Oracle Data Integrator
Oracle Warehouse Builder
OSG
OWB
parallel DML
partitin exchange load
Partitioning
PDML
Performance
PL/SQL
SQL
statistiken
Trivadis
TrivadisContent
Materialized View Refresh for Dummies
Materialized Views are often used in data warehouses to improve query performance on aggregated data. But what if it takes too long to refresh the materialized views? Here are some basic rules to improve refresh performance. Unlike indexes, materialized...
Veröffentlicht
18 Feb 2019 21:19
von
triBLOG
Gespeichert unter:
SQL
,
Oracle
,
Performance
,
ETL
,
Materialized Views
Issue with the Hint ENABLE_PARALLEL_DML
Performing an ETL with large data sets, it is often a good idea to run DML in parallel. But, in contrast to parallel query or DDL, parallel DML have to be explicitly enabled. You had to issue ALTER SESSION ENABLE PARALLEL DML in the past. Starting with...
Veröffentlicht
27 Jan 2019 23:28
von
triBLOG
Gespeichert unter:
SQL
,
Oracle
,
Trivadis
,
ETL
,
Data Warehouse
,
CBO
,
PDML
,
parallel DML
Online Statistics Gathering for ETL – Part 3
Preparing my session on Online Statistics Gathering for ETL for the DOAG conference, I noticed some points that I didn’t covered in the previous two blog posts. The first point is showing the problem that may arise if indexes are involved. The second...
Veröffentlicht
4 Nov 2018 22:32
von
triBLOG
Gespeichert unter:
SQL
,
Oracle
,
Trivadis
,
ETL
,
Data Warehouse
,
12c
,
CBO
,
18c
,
incremental statistics
,
partitin exchange load
,
online statistics gathering
,
OSG
10 Tips to Improve ETL Performance – Revised for ADWC
The Autonomous Data Warehouse Cloud (ADWC) is a self-configuring, fast, secure and scalable platform for data warehouses. Does this mean we don’t have to take care anymore about performance of our ETL processes? Which performance tips are still important...
Veröffentlicht
20 Jul 2018 15:29
von
triBLOG
Gespeichert unter:
SQL
,
Oracle
,
Cloud
,
Performance
,
ETL
,
ADWC
Gathering Statistics in the Autonomous Data Warehouse Cloud
Optimizer statistics are essential for good execution plans and fast performance of the SQL queries. Of course, this is also the case in the Autonomous Data Warehouse Cloud. But the handling of gathering statistics is slightly different from what we …...
Veröffentlicht
11 Jul 2018 17:46
von
triBLOG
Gespeichert unter:
Oracle
,
Cloud
,
Performance
,
ETL
,
ADWC
External Tables in Autonomous Data Warehouse Cloud
In Oracle Autonomous Data Warehouse Cloud, External Tables can be used to read files from the cloud-based Object Storage. But take care to do it the official way, otherwise you will see a surprise, but no data. Together with my … Continue reading...
Veröffentlicht
4 Jul 2018 23:29
von
triBLOG
Gespeichert unter:
Oracle
,
Cloud
,
ETL
,
Oracle 18c
,
ADWC
Online Statistics Gathering for ETL – Part 2
In the first part we looked at general preconditions for online statistics gathering to work and some restrictions. In this part we’ll take a look at what happens with direct path loads into partitioned tables. Partitioning There are also some points...
Veröffentlicht
29 Mai 2018 21:28
von
triBLOG
Gespeichert unter:
Oracle
,
Trivadis
,
ETL
,
Partitioning
,
Data Warehouse
,
12c
,
CBO
,
statistiken
,
bulk load
Online Statistics Gathering for ETL – Part 1
Online Statistics Gathering has been introduced in 12c and is a very handy feature for ETL and batch jobs developers. However the devil is in the detail. There are some points to remember. Let’s take a closer look. Introduction If you are not familiar...
Veröffentlicht
29 Mai 2018 21:27
von
triBLOG
Gespeichert unter:
Oracle
,
Trivadis
,
ETL
,
Data Warehouse
,
12c
,
CBO
,
Merge
,
statistiken
,
on the fly
,
bulk insert
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
1
2
Weiter >
CC BY-NC-ND - Michael Greth
3DZL:andrewbelon.com
Datenschutzerklärung