OWB - Insert multiple rows per key.. 1

[Kioutie]

Hi all!

I have this problem using Oracle Warehouse Builder:
In my source table, i have this key:
No_usag, typ_sdu and seq_sdu. This is call a 'SDU'.
In my target table, i want more than one record by SDU, per example:
SDU NAS FEF CA
1111111111TQ0001 111111111 2002-12-31 100 000
1111111111TQ0001 111111111 2003-12-31 150 000
2222222222TQ0001 222222222 2002-12-31 54 223

The FEF field is a date generated, on per year between a date in a parameter table et the year of the SYSDATE.
So, i have to generate a record by year for each SDU.
In pl/sql i know how i would to this, but in OWB, how can i do ??????????

THANKS A LOT!! (-:

 

[Subhashab]

Hi ,
you can generate OWB script to consider cursor method instead of the normal SQL (insert select ) format. Then modify the PL/SQL generated to the way you want.
Another method would be to add a view of ur time dimension table to include generate only distinct years. use this table in the mapping and put the necessary where clause for you date range. the select in the sql will then be generated with multiple records depending on the year in the time dimension view.

 

[Kioutie]

Hey WOW !! You Really gave me an idea, you genius!!
Thanks a lot, for taken the time to reply to my question..
(And excuse my english.. )

 

[Subhashab]

hi,
thks for the praise. please if you find the answer really good post it as useful

and no more praising that is what we all are here to help each other right