Profile cover photo
Profile photo
Andhra pradesh temples and Tourist places
23 followers
23 followers
About
Posts

Post has attachment
Add a comment...

Post has attachment
How to free some space in Teradata Database
We may come across situation in which we may be encountering errors related with non availability of Storage Space in Teradata. For example: “NO MORE ROOM IN DATABASE” or “NO MORE SPOOL SPACE IN DATABASE” How to free some space in Teradata Database So what ...
Add a comment...

Post has attachment
Real time issue in Teradata
This error will happen when you update the target with multiple rows from the source. If you defined primary index field for your target and if you defined those fileds in update query condition, this error will be obvious one. For example, UPDATE tbl_emp F...
Add a comment...

Post has attachment
Operational DataStore(ODS)
An  ODS  stands for - O perational  D ata S tore. ODS is a database which is designed to integrate data from multiple sources for additional operations on the data like - cleaning, resolving redundancy and checking against business rules for integrity etc. ...
Add a comment...

Post has attachment
Fact tables
Fact - A fact table typically has two types of columns, foreign keys to dimension tables and measures those that contain numeric facts. A fact table can contain fact’s data on detail or aggregated level. Types of Facts - Additive: Additive facts are facts t...
Add a comment...

Post has attachment
Dimension tables in datawarehouse
Dimension - A dimension table typically has two types of columns, primary keys to fact tables and textual\descreptive data. Types of Dimensions - Slowly Changing Dimensions:   Attributes of a dimension that would undergo changes over time. It depends on the...
Add a comment...

Post has attachment
What is a staging area? Why we need it? What is the purpose of a staging area?
Staging area is place where we the hold temporary tables on data warehouse server. Staging tables are connected to work area or fact tables. We basically need staging area to hold the data for cleansing(removing spaces/nulls or to provide expected date form...
Add a comment...

Post has attachment
Types of Schemas in dimensional modeling:
 Below are the types of schema in dimensional modeling with their advantages and disadvantages:- Star schema  :- A logical structure that has a fact table containing factual data in the center, surrounded by dimension tables containing reference data, which...
Add a comment...

Post has attachment
What is Datamart ? why we need it? Types of Datamarts
Definition of datamart :– Datamart is a subset of a Data Warehouse that supports the requirements of a particular department or business function. Data Mart is specialized single-line of business warehouses. Data Mart collects data for a single department o...
Add a comment...

Post has attachment
Data Mining
Data mining  is a process of extracting hidden trends within a datawarehouse. Example –An insurance datawarehouse can be used to mine data to identify the most high risk buildings to insure in a certain geographical area . Data Mining also involves analyzin...
Add a comment...
Wait while more posts are being loaded