|
|
|
ETL TOOLSS
|
 |
Number of Views: |
141 |
| Contact Person |
Sujay |
| Trainings Offered |
Datastage |
| About Institute |
DATASTAGE, OBIEE, INFORMATICA ONLINE TRAINING WITH REAL TIME SCENARIOS
Datastage
DATAWAREHOUSING CONCEPTS: Duration: 36 Hrs.
| INTRODUCTION TO DATAWAREHOUSING |
ü 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
| Data Warehousing Architecture |
ü 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?
ü Different types of SCD’s
| IBM WEBSPHERE DATA STAGE AND QUALITY STAGE VERSION 8.0.1 Contents |
ü Introduction about Data Stage
ü Difference between Data Stage 7.5.2 and 8.0.1
ü What’s new in Data Stage 8.0.1?
ü What is way ahead in Data Stage?
ü IBM Information Sever 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)
ü 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
ü 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
ü
ü Head
ü Tail
ü Pea
ü Row Generator
ü Column Generator
ü Sample
ü Difference between Local Container and Shared Container
ü Local Container
ü Shared Container
ü Arrange job activities in sequencer
ü Triggers in Sequencer
ü Notification activity
ü Terminator Activity
ü Wait for file activity
ü Start loop activity
ü Execute command activity
ü Nested Condition activity
ü Routine activity
ü Exception handing activity
ü User variable activity
ü End loop activity
ü Adding Checkpoints
ü Introduction to Data stage Director
ü Job Status View
ü View logs
ü Scheduling
ü Batches Creation
ü Cleaning resources using Administrator
| Web sphere Manager in Designer |
ü Introduction about Data stage Manager
ü Importing the Job
ü Exporting the Job
ü Importing Table Definition
ü Different types of table definitions and their differences.
ü Importing Flat File Definition
ü Routines
| Dataset management and ORCHADMIN |
ü Quick search and Advanced search
ü Data stage Administrator
ü Creating project, Editing project and Deleting project
ü Permissions to user
ü Different kinds of variables in Data Stage
ü Cleaning resources using Administrator
ü What is Date Quality and why do we for data quality?
ü Integration of Data Quality in Data Stage?
ü Data stage Quality stages
ü Investigate stage
ü Standardize stage Match Frequency stage
ü Unduplicate Match stage
ü Reference Match stage
ü Survive stage
ü Standardized rule sets.
ü Components of Standardized rule sets.
ü Match designer
ü WAVES
Sujay
ETL TOOLS
Srinivasa Krupa,
Hasmathpet,
Near Trimulghery,
Secunderabad.
500015
etltoolss@gmail.com
9866337014
|
| Address / Colony |
Sujay
ETL TOOLS
Srinivasa Krupa,
Hasmathpet,
Near Trimulghery,
Secunderabad.
500015
etltoolss@gmail.com
9866337014
/
Trimulghery |
| City |
Secunderabad |
| Phone |
9866337014 |
| Mobile Number |
|
| Website |
|
| Trainings Center Ratings |
Not Yet Rated. Please Add your Review and help people |
| View Postings by this Trainer |
|
Contact Training Center
|
|
Student /
Training Center
We have
2590 Registered Training Centers
