Silvia Cai

In this blog, I will be describing how to configure Tableau 10 Desktop connection to Apache Drill and explore Hive or HBase instantly on Hadoop. By using the combined feature of these tools, we are convenient to get direct access on semi-structured data such as key-value format and even document storage, without having to rely […]

UDMH Model Components The Perficient Healthcare Analytics Gateway asset is a data integration engine that allows healthcare data from multiple sources be integrated and presented in atomic level detail (Inmon model) and in conformed dimensional layer (Kimball model). The atomic and dimensional data models are part of IBM’s Unified Data Model for Healthcare (UDMH). IBM […]

Symptom When we transform a Dimensional Warehouse Logical Model to a Physical Data Model, IBM InfoSphere Data Architect results in the error ” Save Failed Java heap space” even though the Physical Data Model size is 0 KB. The full error message is as following: Cause Dimensional Warehouse Logical Models are quite large which can […]

Typically, the customization of the Atomic Warehouse Model is driven by the customization performed on the Business Data Model in the context of a project. And if a preexisting element of the Business Data Model got customized, the customization needs to be reflected accordingly into the Atomic Warehouse Model. Or Dimensional Warehouse Model have the […]

IDA Model Change Report is helpful when analyzing the differences between industry models and customized content. It can give attribute, entity, relationship level different between two models. You can find change reports at folder “{install folder}\IBM\Industry Models\IBM Unified Data Model for Healthcare\v9.1.0.0\Data_Models \Change Reports” after install Industry Models. You will see six BIRT reports in […]

Aginity Workbench is a GUI-based tool that enhances your performance when you are working with your Netezza data warehouse. Data import in the Aginity workbench has a fairly easy method to get data into Netezza system. Aginity workbench provides a couple of options to import data from Excel, CSV, Fixed width and external databases. Best Option: […]

As with most BI tools, QlikView can use Apache Hive (via ODBC connection) as the SQL access to data in Hadoop. Here we are going to talk about qlikview how to connect Hortonworks Hive via ODBC. Prerequisites 1.Those are versions of each component we installed in Hortonworks Hue HDP Hadoop Hive-Hcatalog Ambari HBase Hortonworks ODBC […]

Here is an example to transfer data between TM1 Instances byTM1RunTI configuration file and some tips for trouble shooting. TM1RunTI is a command line interface tool that can initiate a TM1 TurboIntegrator (TI) process from within any application capable of issuing operating system commands. That means it can be called cross TM1 Instance, especially when […]

We examine SCD Type I and Type II here. Overview of Kettle transformation Here is overview of transformation. It will be loaded from excel source file and loaded into database.

In this blog we will talk about how to implement various types of slowly changing dimensions (SCDs) with Kettle in details. And I will introduce the examination of SCD Type I and Type II in Part2. Types of Slowly Changing Dimensions Following Kimball, we distinguish two main types of slowly changing dimensions: Type I, Type […]