21 September, 2018
From various types of sources like RDBMS systems (oracle, SQL, server, tera data, sy base etc), files (txt, xml) and ERP systems like (SAP, people soft … etc)
It is a process of transforming the data from one format to another format (client required format) by applying business lagiees
It is a process of converting inconsistent data (means UN uniform data ) in to consistent data (uniform data ) and removing un wanted data.
Cust no cust f name cust l name amt loc
1 bill gates 50000 Newyork
2 bill Clinton 70000 boston
3 nara chandrababu 40000 hyderabad
Cust no cust name amt tax loc
1 billgates 5000 500 Newyork
2 billClinton 7000 700 boston
3 narachandrababu 4000 400 hyd
Staining area :
It is a process of combining multiple sources into a single target (single output) (or) it is a process combining multiple input flows into a single output flow there are two types of data merging
It is a process of combining multiple sources which are having same structure (number of columns should be same and the data types of the corresponding columns should be same)
To perform join, there should be at least one common column between the sources, sources can be homogeneous (or) hetero genius.
Ex: source 1
It is a process of converting the details data in to summary data by applying group functions like sum, max, min, avg, count.
Desired to gain proficiency on Cognos? Explore the blog post on Cognos training online to become a pro in Cognos.
It is a process of populating (or) dumping the source data (OLTP) into the target system (DWH) there are 2 types of data loading
Leading the data for the first time from source to target is called initial load (or) full load
It is a process of inserting new records and updating existing records when coming with new values
It is a subset of data ware house (or) it is a subject oriented database to support middle level management (or) it is a high
There are two approaches to design the data mart
For indepth understanding Cognos Training click on
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .