Data Stage
DataStage (DS) is an ETL tool that can extract data, transform it, apply business principles and then load it to any specific target. It is a part of IBM’s Information Platforms Solutions suite and also that of InfoSphere. DataStage makes use of graphical notations for constructing data integration solutions. It can integrate all types of data, which includes big data at rest or in motion, and on platforms that may be distributed or mainframe in nature.
DataStage is also known as IBM InfoSphere DataStage.
DataStage is also known as IBM InfoSphere DataStage.
Objects:
- Parallel Architecture
- DataStage Configuration and Administration
- MetaData
- Handling data from Files
- Databases
- Data Transformation
- Job Components&Design
- Monitoring and Troubleshooting
IBM DATA STAGE
1. Parallel Architecture
- Data stage architecture.
- SMP , MPP systems
- Datastage clients and their usage.
- Data partitioning and collection Techniques.
- Parallel execution
- Types of Datastage jobs: Overview
2. DataStage Configuration and Administration
- create and configure a project.
- Configuration file & its components
- Creating Users and assigning roles.
3. MetaData
- Orchestrate schema.
- methods of importing metadata.
- runtime column propagation.
- respository functions.
- Schema Files
4. Handling data from Files
- importing/exporting data to/from framework
- sequential file.
- usage of CFF ( Complex Flat File)
- usage of FileSets and DataSets.
- Describe use of FTP stage for remote data.
- Identify importing/exporting of XML data.
5. Databases
- selection of database stages and database specific stage properties.
- Identify source database options.
- Target database options.
- working with NLS database sources and targets.
6. Data Transformation
- Explict/Implict type conversions,
- output mappings
- selections of Transformer stage vs. other stages.
- Transformer stage capabilities
- (including: stage variables, link variables, DataStage macros, constraints, system variables, link ordering.)
- Identify process to add functionality not provided by existing DataStage stages.
- (e.g., wrapper, buildops, user def functions/routines).
7. Job Components
- Copy ,modify, filter, switch Stages,
- SORT stage.funnel , remove duplicates
- Join, Lookup and Merge stages.
- Aggregator stage.
- change capture/change apply.
- Surrogate key generator stage ,SCD stage
- Pivot Stage,
- Row generator ,column generator stage
- Column Import and Column Export stages
- Debugging stages.
8. Job Design
- Parameter sets
- shared containers.
- multiple instance jobs.
- managing datasets.
- Parallel and basic routines.
- Before and after job subroutines
- Demonstrate knowledge of real-time vs. batch job design.
9. Monitoring and Troubleshooting
- Job monitoring
- parallel job score.
- identify areas that may improve performance.
- Common errors and solutions.
- Job repots.
10. Job Management and Deployment
- knowledge of advanced find.
- impact analysis and job compare.
- change control process.
- Import and export of Code.
11. Job Control and Runtime Management
- Creating a job sequence
- activity stages , Triggers and expressions
- Restartability.
- Job Scheduling.
- message handlers.
- dsjob command line utility.
- Job Locks , Status File info.
Our distinct services include :
- Material and Documents: We provide real time working documents and materials to our students.
- Free System Access : We have the latest and most up to date platforms deployed on high-end servers that are available remotely and in-class on a 24/7 basis.
- Interview Preparation: We will prepare you for interviews in your specialized area by providing some real time interview questions. We also conduct mock interviews and assist you in preparing a professional resume.
- Placement Assistance: Our placement service division provides job placement support by submitting your resumes to prospective clients and emails you any new job opportunities in the market. However, we do not provide false guarantees on securing any jobs for you. We have a history of several ex-students who have secured excellent jobs based on our WORLD class training approach, implementation of case study projects and post training support.
- Initial Job Stabilization Support: We support our students to get stabilized in their job in the first TWO months. If our students come across any issues, we are there to help them. Students can send an email to us with their issues, our experts will reply back with possible solutions within 24 hours.
- Free Class Room sessions recording: In addition to the e-class training, we will give you authorization to record all of your e-class room training sessions, so that you can go back and review.
Other Courses related
Course registration
Instructor Led Hands-on eClassroom Training.
Key Points of Training Program :
Data Stage Courses, Learn with Online Practice, in-class Seminars, Training and Certification from the list of world-class education trainers. Macropus provides Class Material, Tutorial Curriculum, Demo Videos, Sample Questions, Recommended Books, Tips and Tricks. Get lectures and practical lessons on development and programming to improve technical skills and Students will benefit with Job Placements, Visa.