Course Content: 1. Data ware housing concepts Describe dimensional modeling 2. Understanding Data Integrator Describe components, management tools, and the development process Explain object relationship 3. Defining source and target metadata Create a database data store and import metadata Create a new file format and handle errors in file formats 4. Validating, tracing, and debugging jobs Use description and annotations Validate and trace jobs Use view data and the Interactive Debugger 5. Creating a batch job Create a project, job, work flow, and data flow Use the query transform in a data flow Use template tables 6. Using built-in transforms and nested data Use the case, merge, and validation transforms Use the Pivot, reverse Pivot Hierarchy flattening 7. Using built-in functions Use date and time functions and the date generation transform to build a Dimension table Use the lookup functions to look up status in a table Use match pattern functions to compare input strings to patterns Use database type functions to return information on data sources 8. Explain differences between global and local variables Create global variables and custom functions Use strings and variables in Data Integrator scripting language 9. Capturing Changes in Data Use Change Data Capture (CDC) with time-stamped sources Create an initial and delta load job Use history preserving transform 10. Handling errors and auditing Recover a failed job Create a manual, recoverable work flow Define audit points, rules and actions on failures 11. Supporting a multi-user environment Describe terminology and repository types in a multi-user environment Create and activate the central repository 12. Migrating Projects Work with projects in the central repository Creation of Profile Repository Understand Profiling 13. Using the Administrator Execute, schedule, and monitor batch jobs Understand architecture, load balance index, and job execution in server Groups 14 Profiling Data Set up the Data Profiler and users Submit a profiling task Monitor profiling tasks in the Administrator 15. Managing Metadata Import and export metadata Use Metadata Reports 16. Data Quality Management 17. SAP Integration Data extraction from ECC system to File, Table and SAP BI. Extract the data from SAP BI & NON SAP Systems using Open hub Services and Data services as 3rd party system.

Topics Covered

Both old version & new version in BODS

Who should attend

anyone

Pre-requisites

Nothing we will gave training from scratch onwards

What you need to bring

1 Note book & Meterial

Key Takeaways

Projects on BODS, Interview Guidance, Prepare the Resume, Clear the Interviews