1 person found this helpful
Sure its possible - Either seed a table in the database with one row per period and cross join that into your flow (to give one amount row per period) or just use a view with something like :
select 'period1' from dual
select 'period2' from dual
Easier with ODI 11G as you can use the sql_as_source Knowledge module with no need for database objects, with 10G you need either the table or the view.
Also, assuming your source is Oracle this IKM may be helpfull.
IKM Oracle (Pivot): Integration Knowledge Module - Pivot data from one row to many rows
I'm not sure if works fine in 10g.