DataWarehousing

When I does my research about Data Warehousing and Big Data , I found some course notes of Dr. Andreas Geppert from University of Zurich. They are really great and easy to understand. If you are new at data warehousing I strongly recommend to check them out. Part 1 ; [flipbook pdf=”https://techbros.com.tr/wp-content/uploads/2020/03/dwh-01.pdf”] https://www.ifi.uzh.ch/dbtg/teaching/courses/DataWarehousing/Unterlagen/dwh-01.pdf Part 2 …

Some Great Resources About Data Warehousing #1 Read More »

Hi ! In this case I need to truncate a partition but I don’t know it’s name. This table has a range partition for every month , so I know HIGH_VALUE of particular partition. We can find partition_name in ALL_TAB_PARTITIONS table but HIGH_VALUE column has CLOB data type. We need a script like below for to change …

Stored Procedure : Truncate Partitions By HIGH_VALUE Read More »