Key Generation in BODS

Key_Generation

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”

Reverse Pivot 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”