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”