Back to overview

Online Magazine

Linked project or discovery?

Key Visual Hack of the week

Often, your DWH (Data Warehouse) will have an ODS (Operational Data Store) as its source. There are 2 possibilities in biGENIUS to access this source data: make a discovery or use the linked project functionality. How to choose the right one for your situation?

 

By Claire Pierreclos

Noob Hack

Use linked projects to avoid unnecessary staging: by using a linked project between your ODS and your DWH, you do not duplicate the ODS data in a DWH staging area. You will spare time of creating a source system, making a discovery, and creating the stage objects. A limitation exists where you should use discovery instead of linked project if you want to filter your source data (like take only valid data in case of delete detection set into the ODS). And before starting using linked project, you must have a good thinking about dependencies of the projects when you will deploy and load them. 

Pro Hack

During linked project creation, you should choose the right Result DWH Part to access the whished objects into your ODS: 

 

 

Usually, these Result DWH Part are configured depending on the linked project type and generator used as for example for the Microsoft Dimensional Generator:

 

 

All the details can be found in our community site.

Hint: If you already are a biGENIUS user and have no access to our community site, please ask the biGENIUS support.  

Read more about biGENIUS

 

Read the next biGENIUS hack

Your contact

SUCCEEDED? THERE'S MORE TO DISCOVER ...

Q&A - the Game
Key Visual Q&A - The Game
Cloud AI

Q&A - The Game Launch Edition
In conversation with
In conversation with Jolanda Spiess Hegglin
AI Analytics

... Jolanda Spiess-Hegglin
TechTalk
Key Visual Tech Talk
Google Analytics

Dschingis Khan & Knowledge Graphs