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 or more tables or views. The SELECT statement is very helpful in finding filtered records from a database.
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 SQL join condition is used in the where clause of select, update, delete statements.
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 Suite. Also known as ‘KETTLE’, Pentaho Data Integration(PDI) is powerful extract, transform, and load (ETL) solution that uses an innovative metadata-driven approach.It is classified as an ETL…
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 I will give introduction about slowly changing dimension(SCD) and types of slowly changing dimension.
SQL – Drop Table is DDL (Data definition language) statement.The Drop Table command is used to delete table from database.
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 definition of its columns.It is used to add, delete or modify columns in an existing table.