Datastage online Training
Feel free to contact
Call : +91-8870903864
Or E-mail
[email protected]
DataStage Concepts
• 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.
• FAQ’s.
Oracle Concepts:
• Introduction to Oracle.
• Data Types.
• Select statement usage.
• Joins.
• Sub Queries.
• Performance Tuning Tips & Tricks.
• FAQ’s.
Datastage - Introduction:
• Introduction to ETL.
• ETL Architecture.
• Datastage Architecture.
• Installation & Configuration of Datastage.
• Creation of the Project.
Datastage - Transforming Data:
• Using the Active stages and passive stages.
• Example of each Transformation available.
• Working with Relational Data.
• Slowly Changing Dimensions.
• Performance tuning techniques.
• Handle errors and exceptions.
• Stage Variables, Derivations and Constraints.
• Functions.
Datastage - Platform Architecture:
• Describing configuration files.
• Defining Environmental Variables.
• Defining Job level parameters.
• Describing Runtime column propagations.
• Exporting and importing the jobs.
• Clear the logs and Cleanup the Resources.
• Job Sequences and Job Activity.
Other Advantages
• Real-time Scenarios.
• Deployment Process.
• Project Experience.
• Resume Preparation.
• Mock Interviews.
• FAQ’s.
• Job Assistance
Datastage training online, Datastage training material, Datastage training cost, Datastage training pdf, Datastage training in USA uae India, Datastage training, online Corporate training malaysia Singapore, Datastage software, Datastage training in bangalore, Datastage training institutes in hyderabad, Datastage training in chennai, Datastage training in hyderabad, Delhi, Mumbai, Pune, Datastage , Datastage webinar, online training singapore, Datastage eam, Datastage as a service, Datastage online Training Datastage online Training Datastage online Training Datastage online Training maximo scheduler, Datastage (consumer product) Datastage online Training Datastage online Training Datastage online Training Datastage online Training Datastage online Training , Post Training Support