Annie Nguyen, InfoZone US asks:
What are the best practices in TimeXtender to create a data model?
Depend on the layer that you are working, DSA, storage of the raw data with some transformation, MDW is the data warehouse, star model, or Snowflake model,
Dear @thagin ,
This is not an easy question: this is asking people to write down all our work experiances. Which, to be honest, would be a great idea.
Just on top of my head:
As TX is a blank slate when you start working with it, sticking to your Way of Working is very important. Discipline and perseverance within your WoW is very important. Some of my best practises are:
And read the datawarehouseing toolkit by Ralph Kimball e.o.!
Hope this helps
!! Very important in my WOW:
No Transformations and translations in the ODX / RAW layer. this cannot be done with the ODX Server (which is a very good thing). But it can be done (and people shouldn't in my opinion) in the (old) Business Units.
Use the description feature on an object when using anything custom like pre/post scripts, they can easily be forgotten
Perfect! great tip
Your question satisfies my gut feel of: “the shorter the question, the more elaborate a good answer needs to be” :-)
Clarity is key, only optimise if required. A clear implementation doesn't waste anyone's time when they try to understand what is going on. It is better to be consistently “wrong” than have different approaches scattered around.
Don't be afraid to process the same data twice if you have differing groups of users with different requirements. It is easier to have and maintain FACT_Orders_Sales and FACT_Orders_Finance than deal with conflicting requirements and develop yourself into a corner.
There's probably a million other things, but I am too young to be writing my memoirs yet...
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.