topic Re: Star schema in SAS Visual Analytics

Star schema with outer joins

Vansh7827 — Tue, 31 Oct 2023 13:09:30 GMT

How to join table in star schema with outer join in Sas viya ??

Re: Star schema

LinusH — Tue, 31 Oct 2023 08:47:38 GMT

Star Schema is a generic concept, so can you please elaborate around your requirement, setting the context?

In SAS Compute you can use PROC SQL, in CAS you could use PROC FedSQL to do the join.

Re: Star schema

LinusH — Tue, 31 Oct 2023 08:49:35 GMT

Update, since you are in V, I realize you men star schema in CAS. This exists in Viya 3.5 only, and has been discontinued in Viya 4 if I didn't get i wrong. SO you want direction how set up a star schema for VA in Viya 3.5?

Re: Star schema

Vansh7827 — Tue, 31 Oct 2023 08:57:30 GMT

We are currently on 3.5 and we are joining the tables using star schema , but only inner join works in Sas viya because of that we are getting data which have common rows and we need outer join. So is there any solution for using outer join ??

Re: Star schema

LinusH — Tue, 31 Oct 2023 13:08:28 GMT

I think the general idea of a star schema is to use it only with inner joins. One aspect that it will perform joins quicker.

As I see it, your work-around is to build "better" dimensions so you don't have to rely on outer joins. This could include "Unknown", or "Other" entries in your dimension tables.

Another option is to create CAS views. I wouldn't expect them to be as fast, especially with outer joins.