This Post describes following:
All the preparatory work needed to define data movement specifications for a flat-file data source to a target data warehouse. In this post you will:
• Define a datastore from Data Services to your target data warehouse
• Import metadata from target tables into the local repository so that you can use the Designer to work with these tables
• Define file formats and a connection to flat-file source data Continue reading “Creating Datastore”
This post gives you a short overview of the Data Services product and terminology.
Data Services Components
The following diagram illustrates Data Services product components and relationships-
Continue reading “SAP Data Services Designer tool”
To generate artificial keys in Data Integrator, you can use either Key_Generation Transform or Key_Generation Function. It fetches max. existing key value from the table and uses it as a starting value. Based on this start key, transform/function increments the key value for each row. Continue reading “Key Generation in BODS”
This is very useful transform for creating Time dimension tables. It generates dates incremented as you specify.
Options: Continue reading “Date Generation transform in BODS”
Reverse Pivot Transform in BODS:
This transform converts rows into columns. It will group the dataset of different rows into a single row with different columns. Observe the icon, it says that will convert rows to column. Continue reading “Reverse Pivot in BODS”
Pivot in Data Services:
This creates a new row for every value that you specify as a pivot column. Observe the icon, it says that it will convert column to rows.
Options: Continue reading “Pivot in BODS”
The Row_Generation transformation is represented by the above symbol.
Definition:- Row generation produces a data set with a single column. The column values start with the number that you set in the option “Row number starts”. The value then increments by 1 to a specified number of rows. Continue reading “Row Generation in BODS”
SQL Transform: You can write your own customized SQL query here. It appears in your dataflow as a source. Use this transform when you cannot perform using other DI transformations. Whatever the SQL entered, it will not be validated by DI. Continue reading “SQL Transform in Data Integrator”
Map Operation in Data Services Designer allows conversions between data manipulation operations. Using Map_Operation transform you can change operation codes on data sets to produce the desired output. Continue reading “Map Operation in BODS”
Case Transformation is used to break a single set of data into multiple sets using a condition.
For example in a spread sheet there is data for Employee Name and Region ID. Using Case and Merge transformation, you can break the Data (Single set of Data) in to multiple sets based on the region ID and store them in separate tables. You can again merge the data from all these tables in to a single permanent table using the Merge transformation. Continue reading “Case and Merge Transformations in BODS”