ETL Testing Life Cycle
Like any other testing process , ETL Testing also goes through various phases called ETL Testing Life Cycle 1. Business and Requirement Analysis : This step involves reviewing and analyzing – Business Requirement Document...
Author: Shikha Katariya
Data Marts
What is a Data Mart ?? A Data Mart is a subset or form of Data Warehouse only but its scope is limited to a particular subject.In other words, It is a specific repository...
Metadata And Data Warehousing
1. Metadata What is Metadata??? Metadata may be defined as’ Data about data’ or ‘Data ( mostly definitions) about the structures containing other data’ . for e.g. a table has four columns , two...
Data warehouse Architecture and Process Flow.
Depending upon the business requirements and the budget , different data Warehouse may have different architectures Types Data Warehouse Architecture – Type 1 : Source (OLTP) —–> Staging Area ——> Data Warehouse ——> Reporting...
Types of Constraints
In the Previous post we studied about ‘ What are Constraints ? ‘. Now we will read about different Types of Constraints. What are the Different Types of Constraints : 1. NOT NULL Constraint...
Constraints in SQL
What are Constraints ?? Constraints may be defined as rules or conditions applied on the data columns of the table, that restrict the type of data entering into the table.They act as filter between...
Data Control Language in SQL ( DCL Commands )
What are DCL Commands ?? Data Control Language or shortly called DCL commands are a set of SQL Commands that provides database security by granting or removing various permissions or privileges for the...
Distinct Clause in SQL
Distinct Clause in SQL is used to fetch only unique values and remove the duplicate values from the result. Key – Points : The changes made by Distinct Clause are not permanent and are...
Backup Table in SQL
Backup Table in SQL, as the name suggests, is the copy of an existing table whose backup we need to take . Constraints on the original table are not copied in the Backup table...
Order By Clause in SQL
Order By Clause in SQL is used to sort the resultset in ascending or descending order. Key – Points : By default it sorts the result in Ascending order. Asc Keyword is used for...