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)