Learn for Life!

What DWA tools are on the market


The 5 top most searched DWA tools compared with GoogleTrends is telling you that WhereScape is first before TimeXtender and BiReady (new Attunity Compose) over the last year. See the… Read more

The 5 top most searched DWA tools compared with GoogleTrends is telling you that WhereScape is first before TimeXtender and BiReady (new Attunity Compose) over the last year. See the…

Read more

Why automate? What does DWA for us?


This article is for you if you considering to use Data Warehouse Automation (DWA) and asking yourself what DWA tools should do for you. After I explain in my previous… Read more

This article is for you if you considering to use Data Warehouse Automation (DWA) and asking yourself what DWA tools should do for you. After I explain in my previous…

Read more

Why Data Warehouse Automation is not more popular


Data Warehouse Automation

I was working with a Data Warehouse Automation (DWA) tool for a little more than a year, and I have to say I loved it. As a BI developer you…

Read more

Data Warehouse Automation (DWA) – Series


Very long time ago, 1986, 31 years ago to be precise, IBM in Europe created the very first architecture of a data warehouse. And it seems to be a masterpiece… Read more

Very long time ago, 1986, 31 years ago to be precise, IBM in Europe created the very first architecture of a data warehouse. And it seems to be a masterpiece…

Read more

Tools I use..


As I’m using a lot of tools on a daily basis which makes my life easier, I’d like to share them with you. Also because lately, I recommending them more… Read more

As I’m using a lot of tools on a daily basis which makes my life easier, I’d like to share them with you. Also because lately, I recommending them more…

Read more

The more you share the more you get..


Quote by Leonard Nimoy.

I’ve experienced the truth of this a long time ago during my apprenticeship, without being aware of it. You probably remember those days when you had to… Read more

Quote by Leonard Nimoy.

I’ve experienced the truth of this a long time ago during my apprenticeship, without being aware of it. You probably remember those days when you had to…

Read more

Migrate from Oracle to Microsoft (Views) – Part III


Continued from Migrate from Oracle to Microsoft (Views) – Part II here part III with the main focus on very interesting topic testing ;-).
Testing
When I implemented all about 20 views from… Read more

Continued from Migrate from Oracle to Microsoft (Views) – Part II here part III with the main focus on very interesting topic testing ;-).
Testing
When I implemented all about 20 views from…

Read more

Migrate from Oracle to Microsoft (Views) – Part II


Continued from Migrate from Oracle to Microsoft (Views) – Part I here part II with more focus on the performance part.
 Performance issues recursive queries
When it comes to performance I had one… Read more

Continued from Migrate from Oracle to Microsoft (Views) – Part I here part II with more focus on the performance part.
 Performance issues recursive queries
When it comes to performance I had one…

Read more

Migrate from Oracle to Microsoft (Views) – Part I


Sometimes you have to migrate from an Oracle database to a Microsoft SQL Server. I’m not going into the reason that could be behind. I had different projects where I… Read more

Sometimes you have to migrate from an Oracle database to a Microsoft SQL Server. I’m not going into the reason that could be behind. I had different projects where I…

Read more

SSAS Cubes – Dynamic generation of partition


There is no easy way to generate partition for SSAS Cubes by default. So you have to do a SSIS-Package  (here is a way you can do it dynamic-cube-partitioning-in-ssas-2008) or… Read more

There is no easy way to generate partition for SSAS Cubes by default. So you have to do a SSIS-Package  (here is a way you can do it dynamic-cube-partitioning-in-ssas-2008) or…

Read more