by Srinivas Vadde | Jun 13, 2022 | Blog, Data Warehousing
Snowflake needs no introduction as it is one of the leading data management platforms on the cloud and its usage is widespread across industry verticals covering multiple use cases (Data Warehousing, Data Lake, Data Science, etc.). It is an open platform which offers...
by Vedha Raman | Oct 12, 2020 | Blog, Data Warehousing
Over the last few decades, ETL testing has been gaining quite a bit of traction. Especially given the emergence of Agile, DevOps, artificial intelligence, and cloud technologies as top trends in the software development industry. The reason for that traction? The...
by XTIVIA | Aug 4, 2020 | Blog, Data Warehousing, Enterprise Information Management
The future of data warehousing has been a popular topic in IT conversations. The outright evolution in technology has seen a recession from on-premise servers and expensive hardware to cloud-based infrastructure devoid of complicated installations. In other words, the...
by Siddhartha Gautam | Mar 9, 2017 | BI/DW, Blog, Business Intelligence, Data Warehousing
Performance issues are one of the primary reason and organizations are unsatisfied with their existing reports. One of the primary reason of this performance issue could be caused by report queries. Here are some of the most important thing to consider when writing...
by XTIVIA | Mar 7, 2017 | BI/DW, Blog, Business Intelligence, Data Warehousing
It’s been estimated that up to 60% of the effort in building a data warehouse can be spent in developing the ETL processes that are needed to copy data from source systems and transform it before loading it in to the data warehouse. Many of the ETL processes,...
by XTIVIA | Jan 7, 2016 | Blog, Business Intelligence, Data Management, Data Warehousing, Databases
This discussion provides an understanding of what is included in a sound backup strategy for your Sql Server data warehouse application. Most data warehouse applications require a different backup and recovery strategy than a typical online transaction processing...