Learn Datawarehousing Here

This blog remains as a handout for all warehouse & etl professionals

Types of ETL testing

Read more »

How to run datastage Job from Unix

How to Run datastage job from Unix

Datastage Scenarios

Read more »

Orchadmin in Datastage

Read more »

Datstage Common Errors and Solutions

Read more »

Business Intelligence Process

Datastage 8.5 v certification Dump

For Datastage Certification dump mail at

Datastage User Manual

Datastage Manual

Order of execution of SQL

Order of execution of sql

Datawarehousing in 4 stages A conventional metod

What are Dimensions and Measures?

Subqueries in SQL

Few Complex SQL Queries

Benefits of implementing a perfect DWH

Codds rules

Basic Practical Perl Tutorial

Shell Scripting

Datastage 8.7 Sample job creation

Newfeatures in Datastage 8.5

AWK programming

Teradata Utilities

Real time Usage of Grep

Regular expressions in Unix

Unix Architecture

VI Editor in Unix

Introduction to unix and basics

Tortoise Subversion

etl & data integration

SQL PERFORMANCE TUNING

Teradata Introduction

Execution of a sql

String Functions in SQl

How do Joins work in SQL?

Datastage Sample parallel Job creation

Parallell processing in datastage

Refrential Integrity

Normalisation in a Database

Types of Data

Data Dictionary of a warehouse

HLD OVERVIEW

Incremental loading in a Warehouse

OLTP vs OLAP

Staging area in a Datawarehouse

What is an ETL Tool?

ER MODELLING

Facts & Dimensions

Snow Flake Schema

What is star schema?

Why you need datamart?

Slowly changing dimension

High level Overview of datawarehousing

Newer Posts Home
Subscribe to: Posts (Atom)

Datawarehousing Concepts

  • ►  2020 (1)
    • ►  August (1)
  • ►  2017 (1)
    • ►  November (1)
  • ▼  2013 (74)
    • ►  November (23)
    • ▼  October (51)
      • Types of ETL testing
      • How to run datastage Job from Unix
      • Datastage Scenarios
      • Orchadmin in Datastage
      • Datstage Common Errors and Solutions
      • Business Intelligence Process
      • Datastage 8.5 v certification Dump
      • Datastage User Manual
      • Order of execution of SQL
      • Datawarehousing in 4 stages A conventional metod
      • What are Dimensions and Measures?
      • Subqueries in SQL
      • Few Complex SQL Queries
      • Benefits of implementing a perfect DWH
      • Codds rules
      • Basic Practical Perl Tutorial
      • Shell Scripting
      • Datastage 8.7 Sample job creation
      • Newfeatures in Datastage 8.5
      • AWK programming
      • Teradata Utilities
      • Real time Usage of Grep
      • Regular expressions in Unix
      • Unix Architecture
      • VI Editor in Unix
      • Introduction to unix and basics
      • Tortoise Subversion
      • etl & data integration
      • SQL PERFORMANCE TUNING
      • Teradata Introduction
      • Execution of a sql
      • String Functions in SQl
      • How do Joins work in SQL?
      • Datastage Sample parallel Job creation
      • Parallell processing in datastage
      • Refrential Integrity
      • Normalisation in a Database
      • Types of Data
      • Data Dictionary of a warehouse
      • HLD OVERVIEW
      • Incremental loading in a Warehouse
      • OLTP vs OLAP
      • Staging area in a Datawarehouse
      • What is an ETL Tool?
      • ER MODELLING
      • Facts & Dimensions
      • Snow Flake Schema
      • What is star schema?
      • Why you need datamart?
      • Slowly changing dimension
      • High level Overview of datawarehousing

About Me

TRYDCSTORE
View my complete profile

Followers

Followers

Watermark theme. Powered by Blogger.