ahy, I think this might help then.... not precisely for your means, yet has the rough details you want (I think)...

erm, not 100% sure what exactly you want..... yet can't you create a table with the headings of....

Title
Department/Division
Position
Type
First Name
Last Name
Xtra Dtls

That would make refrencing much easier, particularly if you ensure search capabilities and queries geared towards that design mode.......

To be honest, there is nothing stopping you from designing...

well.... the cheating method would be to copy the structure from the OD DB, then alter the permissions....turn of edit, update and append, then generate the various reports....like I said, cheating!...

Sorry... I can't help... but if I could ask some details.... what is data warehousing?
Operational DB.... the DB a company uses during the day?
Warehouse DB.... somewhere you put backups?

hmmm. I know nothing about Java.... what file types can it accept?
I assume that it can take in text - comma/tab delinated files, so almost any DB program can provide that sort of output.....

It...

Hmm... no genius, but I think you can do it several ways.... depends on what you want!

You could have one db.... and just limit the access to things dependant upon user...ie the branches can only...