Skip to Content
0
Dec 12, 2022 at 05:04 PM

DWC : Analytical dataset vs Relational dataset

551 Views Last edit Dec 13, 2022 at 10:23 AM 2 rev

Hello Expert,

I would like to understand which is the difference between Analytical dataset and Relational dataset,

At database level.

Beccause we had an example of a SQL Script view with a cross join that If used as Relational dataset it does OOM error for a simple data preview.
Instead if used as Analytical dataset, it gives a correct preview.

image.png

Are there any difference in the execution engines involved?

Thank you

update:

it seems related to the key definition rather than the "Semantic usage".

Attachments

image.png (21.6 kB)