About Course
Datastage Course Description
SUN trainings DATASTAGE Online Training: Experience the real time implementation of datastage projects by exploring data warehouse life cycle, data modeling for data warehouse, IBM DataStage ETL tool, Online DATA STAGE Training in USA, CANADA, UK, Hyderabad,Banglore,India
Course Name: Datastage Online Training
faculty:Real time Experience
Frequently Asked Questions
- You will never miss a class at Suntrainings! You can choose either of the two options:
- 1. You can go through the recorded session of the missed class and the class presentation that are available for online viewing through the LMS.
- 2. You can attend the missed session, in any other live batch. Please note, access to the course material will be available for lifetime once you have enrolled into the course.
- Sun Trainings is committed to provide you an awesome learning experience through world-class content and best-in-class instructors.
- We will create an ecosystem through this training, that will enable you to convert opportunities into job offers by presenting your skills at the time of an interview. We can assist you in resume building and also share important interview questions once you are done with the training. However, please understand that we are not into job placements.
- We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrolment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in the class.
- All instructors at Sun Trainings are senior industry practitioners with minimum 10 - 12 years of relevant IT experience. They are subject matter experts who trained by Sun Trainings to provide impeccable learning experience to all our global users.
- You can Call us at +91 9642434362 OR Email us at contact@suntrainings.com. We shall be glad to assist you.
Datastage Course Curriculum
- An Introduction of Data warehousing
- purpose of Data warehouse
- Data ware Architecture
- OLTP Vs Data warehouse Applications
- Data Marts
- Data warehouse Lifecycle
- SDLC
- Introduction of Data Modeling
- Entity Relationship Model
- Dimensions and Fast Tables
- Logical Modeling
- Physical Modeling
- Schemas Like Star Schema & Snowflake Schemas
- Fact less Fact Tables
- Introduction of Extraction , Transformation and Loding
- Types of ETL tools
- Key tools in the market
- Windows server
- Oracle
- .NET
- Datastage 7.5X2 & 8x
- Server jobs & Parallel jobs
- Administrator clint
- Designer client
- Director client
- Import/export manager
- Multi client manager
- Console for IBM imformation server
- Web console for IBM imformation server
- Datastage Introduction
- IBM Information server Architecture
- IBM Data Quality Architecture
- Enterprise Information Integration
- Web Sphere DataStage Components
- About Web Sphere DataStage Designer Partitioning Methods Partitioning Techniques Designer Canvas Central Storage Job Designing Creating the Jobs Compiling and Run the Jobs Exporting and importing the jobs Parameter passing System(SMP) & Cluster system(MPP) Importing Method(Flat file, Txt, Xls and Database files) OSH Importing Method Configuration file
- DATABASES STAGES
- Oracle Database
- Dynamic RDBMS
- ODBC
- SQL Server
- Teradata
- Sequential File
- Dataset
- Lookup File set
- Peek
- Head
- Tail
- Row Generator
- Column Generator
- Slowly changing dimension stage
- Slowly changing dimensions implementation
- Aggregator
- Copy
- Compress
- Expand
- Filter
- Modify
- Sort
- Switch
- Lookup
- Join
- Marge
- Change Capture
- Change Apply
- Compare
- Difference
- Funnel
- Remove Duplicate
- Surrogate Key Generator
- Pivot stage
- Transformer
- Shared Containers
- Local Containers
- About DS Director
- Validation
- Scheduling
- Status
- View logs
- Monitoring
- Suppress and Demote the Warnings
- Peek view
- Create Project
- Delete Project
- Protect Project
- Environmental variables
- Auto purge
- RCP
- OSH
- Commands Execute
- Multiple Instances
- Job Sequence Settings
- Job Activity
- Job sequencer
- Start loop Activity
- End loop Activity
- Notification Activity
- Terminator Activity
- Nested Condition Activity
- Exception handling Activity
- Execute Command Activity
- Wait for file Activity
- User variable Activity
- Adding Check Points
- Restartable
- Data Quality
- Data Quality Stages
- Investigate Stage
- Standardize Stage
- Match Frequency Stage
- Reference Match Stage
- Unduplicated Match Stage
- Survive Stage
- Viewing audit details in operational DASHBOARD reports
- FAQS
- Covering DBA concepts
- Concentration on performance tuning
- Real time scenarios
- Certification guidance
- Resume preparation
- Sample resumes
- Interview & certification FAQS
- How to face the interview
- Class notes which is useful for who is trying for job
- Project preparation
Trainer Information
- Trainer has 15+ years of experience in IT industry.
