How to Choose Right ETL tool ?
So you planning to build Data Warehouse? But not able to decide which is the right ETL tool for you business.I can understand your confusion...
SQL Interview Questions and Answers
1. What is SQL ? SQL stands for Structured Query Language.It is a database language used for database creation, deletion, fetching rows and modifying rows...
SQL – Select Statement
Select statement is a DML (Data Manipulation Language) statement.The SELECT statement is an SQL statement that specifies which rows and columns to fetch from one...
SQL Join
A SQL Join clause is used to combine rows from two or more tables, views, or materialized views based on a common field between them. A...
Pentaho Data Integration(PDI)
Pentaho Data Integration(PDI) is the most powerful open source ETL tool available in market. It is one of the important tools available in Pentaho BI...
Slowly Changing Dimension SCD
In Data Warehouse, problem of slowly changing dimension is a common one. This applies to cases where the attribute for a record varies over time. Today...
SQL – Drop Table
SQL – Drop Table is DDL (Data definition language) statement.The Drop Table command is used to delete table from database. Drop Table Statement : Removes named table...
SQL – Alter Table
SQL – Alter Table is DDL (Data definition language) statement.The ALTER TABLE command is used to modify the definition (structure) of a table by modifying the...
SQL – Create Table
Create Table is a DDL (Data definition language) statement. The CREATE TABLE is used to create and define a new relational table. CREATE TABLE Statement :...
Types Of Fact
Till now, we have already discussed about types of dimension. So lets move to another concept in dimensional modelling, i.e, FACT . A fact is a...