UNIX commands for ETL Testing in Data Warehouse

UNIX commands for ETL Testing UNIX Command Purpus ls list out the files ls -ltra list out the files including hidden files ...

Read More...

BI DWH OLTP DRAFT

Introduction to Basic BI Concepts What is Business Intelligence Definitions •Howard Dresner’s definition - business intelligence is an umbrella term to describe ‘concepts and methods to improve business decision making by using fact-based support systems’ •Business intelligence (BI) is the set of...

Read More...

OLTP - On-line Transaction Processing

Introduction to OLTP: What is OLTP? Definition: OLTP stand for "On-line Transaction Processing", it is an operational database that supports or facilitates high transaction-oriented applications. Operational data...

Read More...

Data warehouse (DWH) Introduction - Design & Concepts

Data warehouse (DW or DWH) also known as an enterprise data warehouse (EDW) What is Data warehouse (DW or DWH): There is a lot of different definitions for a data warehouse. The simple and popular definition was...

Read More...

ETL Testing Interview Questions and answers

ETL Testing Interview Questions and answers. .1   What is a Data Warehouse? :    A Data Warehouse is a collection of data marts representing historical data from different operational data source (OLTP). The data from these OLTP are structured and optimized for querying and data...

Read More...

Data Normalization

Data Normalization In this section you will learn the concepts of data normalization. The most important thing in database designing is to make sure that the data get properly distributed among the tables. Simply we can say that the designing of  the table in proper manner is called Normalization. Normalization...

Read More...

BI Data Warehouse Architecture / Diagram

Data Warehouse Architecture Data Warehouse Architecture can be design in different way. Its depend on the specific business requirement that means it’s vary depending upon the specifics of an organization's need. Below...

Read More...

Data Warehouse and ETL Testing Concepts

This post contains the topics related to Data Warehouse and ETL Testing Concepts, if you want to be a ETL Tester you should know the below terminology. Click on the link to get more information. BI CONCEPTS DATA WAREHOUSE (DWH) DESIGN & CONCEPTS:            ...

Read More...

WhatsApp Web launched and now available on the Desktop via Google Chrome browser

WhatsApp Web WhatsApp, popular messaging app has launched web client known as WhatsApp Web.Now WhatsApp Web can be accessible through Web URL: https://web.whatsapp.com in your Google Chrome...

Read More...

SQL Server Reporting Services (MSSQLSERVER) - ERROR: 1053

Description: Windows could not start the SQL Server Reporting Services (MSSQLSERVER) service on local computer. Error 1053: The service did not respond to the start or control request in a timely fashion. Cause...

Read More...

ETL Job or Components

ETL Components: ETL Job or Components Data Extraction Data Transformation Data Loading Data Refresh Method Data Sourcing Method Data Landing / Staging Design Job Scheduling Job Sequencing Historical Data Migration Changed...

Read More...

List of Popular ETL Tools/Software

List of Popular ETL Tools/Software Commercial ETL Tools: Informatica – PowerCenter IBM – Infosphere Information Server Oracle Data Integrator (ODI) Oracle Warehouse Builder (OWB) Microsoft - SQL Server Integration Services SAS - Data Integration Studio SAP - BusinessObjects Data Integrator IBM...

Read More...