Explain Process flow in data warehouse??

Question Posted / vignesh

Explain Process flow in data warehouse??..

Answer / parvar

1 Source to Staging Area
2 Staging area to work space
3 Work Space to data ware house

Is This Answer Correct ?

2 Yes

0 No

More Data Warehouse General Interview Questions

what is parallelism?

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

How can Oracle Materialized Views be used to speed up data warehouse queries?

What is a core dimension?

What are universe requirements?

Explain the difference between oltp and olap?

What are components of report studio?

What Oracle features can be used to optimize my Warehouse system?

What are non-additive facts in detail?

suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?

3.What is fact less fact ?

What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

For more Data Warehouse General Interview Questions Click Here