Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
alexandernatale
Creator II
Creator II

Best practices for expressions: flag and set analysis

Hello everybody,

I'm reading Kimball's book (The data warehouse toolkit) and in one of the first practical examples the creation of "talking" flags instead of binary (Y / N or 0/1).

In the best practices in QS instead it is expressly indicated not to use textual flags.

Here is a part of the text:

"Rather than decoding fl ags into understandable labels in the BI application, we prefer
that decoded values ​​be stored in the database so they're consistently available to all
users regardless of their BI reporting environment or tools. "

How do you position yourself on this diatribe?

Labels (5)
0 Replies