I have a master dataset (30+ million records) that updates every quarter. I also have a look-up table with about 900 records in it that updates every 2 weeks. I would like to know from others the best way to create a look-up between the values in both datasets without having to re-load the master dataset. I have reviewed the process for using a join, create view and formats. Any expert and practical advice is much appreciated!
Reload a table of that size every two weeks doesn't sound like an issue ix you don't have extreme 24/7 requirements. Formats saves memory but there have been some quality issues with then in the product. Not sure if all those are fixed in 7.3. What do you mean by a view? A star schema? That could work fine if the usual query results in small subsets.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.