Realtime Scenario7

Real time scenario 6

REALTIMESCENARIO4

qualifyng nth record using row_number and partition by within a group in teradata

qualifyng nth record using row_number and partition by within a group in teradata

difference between not in and not exists in teradata

difference between not in and not exists in teradata

using QUALIFY ROW_NUMBER WITH PARTITION BY IN TERADATA

using qualify row_number over partition by in teradata

USING CAST WITH CASE IN TERADATA

USING CAST WITH CASE IN TERADATA

REAL TIME SCENARIO3

Real time scenario2

Resume for ETL Developer (Data Stage)

Complex sql queries in oracle

Different Industry DataModels

Different domain data models

Datastage 000-421 certification dumps

Datastage 8.5 certification dumps

Datastage Realtime scenario1

Learn ControlM Here

ControlM Tutorial

IBM Webshpere Datastage 8.1-Orchadmin Command

IBM Information Server / Datastage Enterprise Edition with Teradata

Overview of oracle database adminstration

Common usage of microsoft excel

Logical Data Model

DATSTAGE & DATAWAREHOUSING INTERVIEW QUESTIONS

DS VS INFORMATICA

DataStage Scenario's

Types of ETL testing

How to run datastage Job from Unix

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

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