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. "