I'm learning about Oracle database and I'm stuck with a problem.
I have a table called "Business" with various columns and I need to populate a second table (DM_Business) using the data from the first one. The second table doesn't have the same columns of the first one.
For example:
- Business: business_id, name, address, state, attributes, activity, hours
- DM_Business: business_id, name, address, id_state, id_activity
The first three columns will be the same; id_state will be populated with a number according to the initial data from state (Alabama -> 1, Alaska -> 2, Arizona -> 3, ...); same thing with id_activity.
I need to use ODI to do this, creating an automatic flow from one table to the other. If it helps both tables belong to the same user, who is also the owner of the master/work repository. I've read and watched lots of tutorial online, but I can't understand how to do it.
Thank you very much for your help, I'm really stuck here. Thanks again.