Hi I want to setup a simple department level data mart. The source data is in an oracle database. The target is also an oracle database. I have the data mart design ready. It is a star schema. I am looking at the various options to A) Move the data from source to target B) Visualization tools to use the data mart
A) For data movement I can either write scripts or use an ETL tool. Is OWB an overkill for my needs? I may have a max of 100,000 records in the fact table. OWB seems to build the dimension tables directly. What if i want to create the schema myself using CREATE TABLE statements and just move the data using OWB. Is it possible?
B) Are there are free tools that I can use to query the data mart created. I want to provide this to end users who will not know SQL.
Thank you Krishnamoorthy B