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 because choosing the right ETL tool is the most daunting task when you are planning to build a data warehouse. Once you chose the right ETL tool, more than 70% of work is done. » Read more
Happiest Minds is looking for experienced Pentaho ETL developers for bangalore location. » Read more
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 etc. » Read more
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. » Read more
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. » Read more
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 tool, however the concept of classic ETL process (extract, transform, load) has been slightly modified in Kettle as it is composed of four elements, ETTL, which stands for Extraction Transformation Transportation and Loading Environment. » Read more