what's is new trend of DW design
My quesion is what's the popular design or architecture currectly for oracle data warehouse?
The architecture of project I did is upstream database(non-oracle) generates a lot of flat data files(txt in Unix). And then we used sqlloader to load all these files into oracle staging tables. After that, we wrote stored subprograms to process and load data into fact or dimension tables.
Every day we loaded millions of rows totally. And the main fact tables have about billions of rows. To be honest, I think this architecture is good, at least not bad.
I worked on this project for one year and then I transfered to oracle application development.