Partitioning ? In DataWarehouses and OLTP systems we use partitions for keeping data separately. In this way when we run a query database engine doesn’t need to scan all the table , it just accesses the partition that needs. Oracle defines its partitioning like this ; Partitioning is powerful functionality that allows tables, indexes, and …
Hi , One of our current projects we are developing a DataWarehouse. We already developed our ETL processes and reports , but it is time for deploy that in prepord environment . The first test set is contains check null control of all the columns in DWH and DM tables. And the second test is …
Testing DWH & DM Tables : Column Fullness And Daily Record Trend Read More »
Hi , I’ve been trying to install a virtual Windows Server 2016 in Virtualbox. My host is Windows 10 Pro for Workstation. I installed windows server2016 successfully, then i realized that I did not increase the number of CPU , I have AMD Ryzen 9 5900x so I can give 8/24 of Virtual Cores. When …
Windows In Virtualbox Does Not Start With More Then 1 CPU Read More »
