|
BODS OVERVIEW
Over view of the Data services
Data services benefits, associated products, interfaces
Data services Architecture on single and distributed environment.
BODS DESIGNER CONCEPTS:
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
BATCH JOBS
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
Defining Data Integrator Transforms
Various Transforms and its implementation
DEFINING DATA PLATFORM TRANSFORMS
Defining Data Platform Transforms
Various Transforms and its implementation
DEFINING DATA QUALITY TRANSFORMS
Address Cleanse
Data Cleanse
Geocoder
Match
IMPLEMENTATION OF SCD
SCD Type0
SCD Type1
SCD Type2
TROUBLESHOOTING BATCH JOBS
Use descriptions and annotations
Validate and tracing jobs
Use View Data and the Interactive Debugger
Use auditing in data flows
USING FUNCTIONS, SCRIPTS, AND VARIABLES
Define built in functions
Use functions in expressions
Use the lookup function
Use variables and parameters
Use Data Services scripting language
DATA ASSESSMENT
Using the data profiler
Using the validation transform
SETTING UP ERROR HANDLING
Set up recoverable work flows
Try/Catch Techniques
IF CONDITIONAL
WHILE LOOP IMPLEMENTATION
CAPTURING CHANGES IN DATA
Update data over time
Use source based CDC
Use target based CDC
SAP INTEGRATION
Data extraction from ECC system to File, Table and SAP BI
Data extraction from ECC Extractors
Data Extraction from SAP BW
ABAP Workflows
|
