Manage I need to changes my migrated databases to make use of connections in place of joins?

Manage I need to changes my migrated databases to make use of connections in place of joins?

When you opened a pre-2020.2 workbook or repository in a 2020.2 type of Tableau, your computer data origin will appear as a single logical dining table during the canvas aided by the title „Migrated Data“. You can rename the Migrated information table.

Your original, denormalized data may have been initially built from just one or even more dining tables making use of joins and unions. Once you start the info source in Tableau 2020.2, Tableau migrates the denormalized data design to just one logical dining table inside the newer information unit to ensure that important computer data and workbooks become moved without modifications.

To see the physical dining tables that make up the unmarried reasonable table, double-click that reasonable desk to start they inside the physical layer. You’ll see the fundamental physical tables, like joins and unions.

For those who have current multi-table information supply defined using bodily covering joins, they are going to still work as they performed earlier. It’s not necessary to change your databases. You are able to connect rational tables to your migrated desk, but you can’t downgrade reasonable dining tables.

You might give consideration to switching you databases to utilize interactions instead of joins when you need to increase the amount of dining tables towards facts product. This can require you to remove tables from the real covering, following incorporate them to the rational covering. Pokračovat ve čtení „Manage I need to changes my migrated databases to make use of connections in place of joins?“