Posts Tagged ‘Data’

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 […]

Almost every type of ETL tool has its extract and load strategy with its configurations. In general the user should be concentrated in full load (aka initial load) and incremental load options in whatever tools to utilize. Oracle BI Apps component provides straightforward options to let developer configure appropriate approaches to achieve data load in […]

Basing on my last blog (IBM Cognos TM1 updating metadata in TI submit time explore), we will explore the influence of updating metadata by sub TI here. Please see below example as scenario 1:

Recently, when we update the dimension elements, we find the value of the cube which includes the dimension are missing. So we need to explore which time moment cause this. Please see below experiment:

In the past couple of years, we have delivered several projects successfully which were based on MVC + KnockoutJS, they all applied the same structure or pattern, so I was thinking to get them out from several projects which we might reuse in the future projects, here is what I’d like to share, you may […]

When you intend to create report utilizing SAP Crystal Reports for Visual Studio 2012, generally speaking, all the report content can be bound with some kinds of data source (like DataSet). However, in some particular scenarios, some report content is not bound to any data source, and you have to change them dynamically, such as […]

Leaders in information technology have traditionally been concerned with their company’s sensitive financial data residing in the cloud.  The concern is that with sensitive data in the cloud, it is at risk of being accessed by the wrong people. After 2014, or as I have seen it referred, the year of the data breach, one […]

Storage is on the mind of many this holiday season. At home, if you are a parent, it’s a question of “Where are we going to store all these overwhelmingly large toys?” At work – it’s more likely to be a data issue. If local storage is your issue, you probably know one of your […]

Problem Description: Several days ago when I ran a PowerCenter session, I encountered an issue of populating column value of money data type from one Microsoft SQL Server table to another. For example, the original source value is 1234.1250, but after I loaded it to another table, it became 1234.1136. In Informatica, the column data […]

In the star-schema based data modeling, it is not very often to turn on slowly change dimension as type 2, while it will bring some advantage to feed some requirements such as ‘show me the history change for one business group folks’, ‘show me the revenue and cost incurred by the employees at point of […]

Scenario We want to create a target flat file name with the current system date. Solution 1 The first method is renaming the target file name in the post session command as bellow: Example: The following command will rename the file in the format filename_MMDDYYYY.out in Windows: move $PMTargetFileDir\filename $PMTargetFileDir\filename_%date:~4,2%%date:~7,2%%date:~10%.out

SSRS is a powerful tool not because it projects queries in really good looking charts but because it enhances user experience.  The reports are so intuitive that users can navigate and export data without much training.  However, as business analyst or data analysts or report designers, it is our responsibility to extend these usability features […]