Datastage - Data WareHouse Course

Training/Coaching/Tuition by Sudeep Technologies Hyderabad View Contact

Request Info

Introduction to Data Warehousing

• What is Data Warehousing?

• Who needs Data Warehousing?

• Why Data Warehouse is required?

• Types of Systems

• OLTP

• OLAP

• Maintenance of Data Warehouse

• Data Warehousing Life Cycle

Database Design and Data Modeling

• Source

• Integration Layer

• Staging Area

• Target

• Analysis & Reporting

• ODS

Multi-Dimensional Modeling

• What is dimension modeling?

• Difference between ER modeling and dimension modeling

• What is a Dimension?

• What is a Fact?

• Start Schema

• Snow Flake Schema

• Difference between Star and snow flake schema

• Fact Table

• Different types of facts

• Dimensional Tables

• Fact less Fact Table

• Confirmed Dimensions

• Unconfirmed Dimensions

• Junk Dimensions

• Monster Dimensions

• Degenerative Dimensions

• What are slowly changing Dimensions?

IBM WebSphere DataStage and Quality Stage, Versions 8.0.1Contents

• Introduction about Data Stage

• Difference between Data Stage 7.5.2 and 8.0.1

• What is way ahead in Data Stage?

• IBM Information Server architecture

• Datastage within the IBM Information Server architecture

• Difference between Server Jobs and Parallel Jobs

• Difference between Pipeline Parallelism and Partition Parallelism

• Partition techniques (Round Robin, Random)

Hash, Entire, Same, Modules, Range, DB2, Auto

• Configuration File

• Difference between SMP/PMP(Cluster) Architecture

• Data stage components (Server components /Client components)

Designer

• Introduction about Designer

• Repository

• Palette

• Type of Links

• File Stages

• Sequential file

• Dataset file

• File set

• Lookup file set

• Difference between Sequential file/Dataset/File set

• Overview of iWay, Classic federation and netezza

• Database Stages

• Dynamic RDBMS

• Oracle Enterprise

• ODBC Enterprise

• Stored Procedure

Processing Stages

• Change Capture

• Compare Stage

• Difference Stage

• Aggregate Stage

• Transformer Stage

• Difference between basic transformer and transformer

• Surrogate Generator Stage

• Join Stage

• Merge Stage

• Lookup Stage

• Difference between Join/Lookup/Merge

• Difference between Join/Lookup

• Remove Duplicates

• Switch

• Pivot

• Modify

• Funnel

• Generic stage

• Different types of sorting and sort stage.

• Different types of combining and collecting techniques.

• Filter

• External filter

• Difference between filter, External filter and switch stages.

• SCD stage

• Encode and decode stages

• FTP stage

• Adding job parameters to a job

• Parameter set

• Difference between partitioning and re partitioning

• Run time column propagation

• Schema files

Debugging Stage

• Head

• Tail

• Pea

• Row Generator

• Column Generator

• Sample

Data stage Director

• Introduction to Data stage Director

• Job Status View

• View logs

• Scheduling

• Batches Creation

• Cleaning resources using Administrator

Sudeep Technologies

SUDEEP TECHNOLOGIES was established with an aspect of providing comprehensive end to end training on various computer software IT courses. Our team consists of high end professionals with vast real time experience who trains you on all courses to bridge the gap between industry and academic graduates.

we provide cost effective training for needy learners with utmost care and guidance according to the demand of job market. Faculty, technically sound in high end technologies will teach you with quality principles and deliver the methodology of easy learning which gets you updated to the current trend. Sudeep Technologies, with dedication provides you the best learning concepts which puts you front in this competitive software world as a successful one.

Our faculty are enough skilled to explore the complicated concepts and explains you in a well descriptive manner.As the pace of technological enhancements is getting faster day by day there is indispensable part of imparting advance concepts to the learners to meet the demand which is the cause for emerge of SUDEEP TECHNOLOGIES.

We are ideal for beginners and an added advantage to the professionals to enhance their skills as we deals in depth with the advance concepts of the courses and also provide implementation-real time concepts. SUDEEP TECHNOLOGIES, renders one to one online training for students in state-of-the-art technology platforms in India or abroad.we save your time and money by avoiding expensive travel through online training. With the latest in collaborative technology, top instructors, cutting-edge curriculum we provide an exciting combination of traditional content and interactive learning and also materials with rich information that shouldn’t make any difference to the class room training.

Personalized online training sessions can be held comfortable to the student ease.without any hesitation, we offer you a100% student satisfaction online program.If you have any queries please contact us through e-mail id or phone or fill the enquiry form with the necessary details.