• Over view of the Data services
• Data services benefits, associated products, interfaces
• Data services Architecture on single and distributed environment

• Creating the repository (Local, Central repository)
• Exploring the menu options in the designer
• Creating the project, Job flow, Data flow, Work flows etc.,
• Defining different types of Data stores (Source and destination data stores)
• Use data store and system configurations
• Defining file formats for flat, Excel, XML files

• Creating Batch Jobs
• Work with objects
• Create a data flow
• Adding the Query transform to the data flow
• Use target tables
• Execute the job

• Defining Data Integrator Transforms
• Various Transforms and its implementation

• Defining Data Platform Transforms
• Various Transforms and its implementation

• Address Cleanse
• Data Cleanse
• Geocoder

Implementation of SCD

• SCD Type0
• SCD Type1
• SCD Type2

• Define built-in functions
• Use functions in expressions
• Use the lookup function
• Use variables and parameters
• Use Data Services scripting language

• Using the data profiler
• Using the validation transform

• Set up recoverable work flows
• Try and Catch Techniques

• Update data over time
• Use source-based CDC
• Use target-based CDC

• Data extraction from ECC system to File, Table and SAP BI
• Data extraction from ECC Extractors
• Data Extraction from SAP BW
• ABAP Workflows