大数据

Relative to traditional business intelligence solutions, Cloud BI is offering a timely and cost-effective path for businesses of all sizes to maximize potential while minimizing costs. To make the mo…

by Myles Gilsenan I attended Oracle OpenWorld (OOW) 2014 recently with a focus on BI, Big Data and ERP. As usual there was no shortage of information. The Partner briefings were particularly helpful …

by Chaithanya Kumar Taduvai ODI developers usually deal with load plans and mismanaged dependencies between multiple-load plans are typically a cause of data corruption in the system. An ideal I…

更新记录转载请注明出处：https://www.cnblogs.com/cqpanda/p/16556436.html2022年8月7日 发布。2022年8月6日 从笔记迁移到博客。 SQL Server 压缩（Compression） 使用压缩的原因 减少磁盘空间 改善性能 缩短查询…

在Navicat中设置id主键为UUID自增   UUID是可以在java后端代码中定义的，但在建表的时候就设置好的话可以简单点 具体方法如下： 添加触发器，然后定义 代码拷贝：（一个字都不要少）这样就可以简单实现id按照UUID自…

今天我们通过 explain 来验证下 sql 的执行顺序。 在验证之前，先说结论，Hive 中 sql 语句的执行顺序如下： from .. where .. join .. on .. select .. group by .. select .. having .. distinct .. order by .. …

环境： vmware workstation prop 15.1 window server 2019 datacenter sqlserver2014 x64 前言： 什么是发布和订阅？ 发布和订阅属于sqlserver的复制技术，引用官网的解释： 复制是一组技术，它将数据和数据库对象…

by Prashanth Gajjala I started working with Oracle Data Integrator (ODI) a year ago while participating in a Oracle Business Intelligence Applications 11.1.1.7 implementation.   I have been work…

by Madan Thota Azure Power BI Automation - DataSets This is the fifth post in KPI's Power BI blog series. In this blog, we provide a high-level overview of dataset refresh and other dataset operation…

MySQL表结构批量自动生成HIVE建表语句 需求描述 数仓建设过程中，在所难免的需要将大量业务数据导入值hive中，当业务比较复杂导致业务相关表过多时， 建表语句的整理和维护工作增大，手动写hive DDL容易出错且耗时…