Notifications
Clear all
Topic starter
True or False: Physical tables remain distinct (normalized), not merged in the data source whereas logical tables are merged into a single, flat table.
- A . True
B. False
Suggested Answer: B
Explanation:
In fact, the opposite of this is true.
Trick: Whenever you think of joins -> Think that after the join is created, we get 1 single flat combined (joined) table. This flat combined table is created prior to us creating our visualizations. This happens at the physical layer.
If you ever think about relationships, know that all tables will remain distinct and separate, and relationships sit at the logical layer. At run time, when you bring in the dimensions and measures to create your viz, Tableau very smartly creates the necessary joins, relates the tables and sends queries to these tables to get the resultant data back in the most meaningful way possible. This allows you to focus on using your data and revealing insights from it and focus less on the data preparation aspect!
Refer to logical layer vs physical layer from the official
documentation: https://help.tableau.com/current/server/en-us/datasource_datamodel.htm
Explanation:
In fact, the opposite of this is true.
Trick: Whenever you think of joins -> Think that after the join is created, we get 1 single flat combined (joined) table. This flat combined table is created prior to us creating our visualizations. This happens at the physical layer.
If you ever think about relationships, know that all tables will remain distinct and separate, and relationships sit at the logical layer. At run time, when you bring in the dimensions and measures to create your viz, Tableau very smartly creates the necessary joins, relates the tables and sends queries to these tables to get the resultant data back in the most meaningful way possible. This allows you to focus on using your data and revealing insights from it and focus less on the data preparation aspect!
Refer to logical layer vs physical layer from the official
documentation: https://help.tableau.com/current/server/en-us/datasource_datamodel.htm
Posted : 12/02/2023 12:28 am