DATA STAGE BEST TRINING IN BLR @MNPTECHNOLOGIES 9880756789.

No. 11, MKB SQUARE, Near Vijay a Bank, Outer Ring Road, Marthahalli Bridge, Bangalore - 37.
9880756789 / 08042277050
MNP Technologies is a leading and premier IT training institute in Bangalore. MNP Technologies provides a high-quality of training to our students and we provide advanced labs to do practical experiments and Classrooms to become an expert in any IT Course.
We provide expert trainers who have work experience in TOP MNC Company across India. Our trainer are real time experience faculty will provide a best training methodology and courseware with 100% real time project scenarios, Cost-Effective and Quality in all the course

DATASTAGE COURSE CONTENT IN TECHIE ZONE

• Data Warehouse Concepts, Design.
• Need of Data Warehouse.
• Introduction to OLTP, ETL and OLAP Systems.
• Data Warehousing Architecture.
• Dimensional Modeling.
• Data Marts and ODS.
• Star Schema and Snowflake Schema.
• Types of Fact and Dimension Tables.
• Testing of Data warehouse.
• SCD Concepts.
• Surrogate key
• FAQ’s.
Oracle Concepts:
• Introduction to Oracle.
• Data Types.
• Select statement usage.
• Joins.
• Sub Queries.
• Performance Tuning Tips & Tricks.
• Order by
• Group By
• FAQ’s.
• Introduction about Data Stage
• Difference between Server Jobs and Parallel Jobs
• Difference between Pipeline Parallelisms and Partition Parallelism
• Partition techniques (Round Robin, Random, Hash, Entire, Same, Modules,Range,DB2,Auto)
• Configuration File
• Difference between SMP/MPD architecture
• Data Stage Components (Server components/Client Components)

Data Stage Administrator:

• Creating project, Editing project and Deleting project
• Permissions to user
• .Apt Comfit file
• Environment variable creation, permission

Data stage director:

• Introduction to Data stage Director
• Job status View
• View logs
• Scheduling
• Batches Creation

Designer:

• Introduction about Designer
• Repository
• Palate
• Types of Links
• File Stages
• Sequential File
• Data set File
• Lookup file set
• Difference between Sequential file/Dataset/File set
• Database stages
• Dynamic RDBMS
• Oracle Enterprise
• ODBC Enterprise
• Run Time Colum Propagation
• Stored Procedure
Processing stages:

• Change Capture (Caption)
• Compare stage
• Difference Stage
• Aggregate Stage
• Transformer Stage
• Surrogate Generator Stage
• Join Generator Stage
• Merge Generator Stage
• Lookup Generator Stage
• Difference between join/Lookup/Merge
• Difference between join/Lookup
• Remove Duplicates
• Switch
• Pivot
• Modify
• F
unnel

Debugging stage:

• Head
• Tail
• Peak
• Row Generator
• Column Generator
• Sample
• Job Parameters
• Validate
• Run
• Monitor
Manager
:
• Introduction About Data stage Manager
• Importing the Job
• Exporting the Job
• Importing Table Definition
• Importing Flat File Definition
• Routines
Containers:
• Difference between Local Container and Shared Container
• Local Container
• Shared Container