Hi Anveksha,
You can create a star schema with a proc cas table.view cas action, just as described in
https://communities.sas.com/t5/SAS-Communities-Library/Query-Performance-Use-a-CAS-Star-Schema-in-SAS-Viya-3-5/ta-p/622970
or
https://communities.sas.com/t5/SAS-Communities-Library/Automatic-Data-Loading-with-a-CAS-Data-Source-Star-Schema-in/ta-p/623458
... View more