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 are the steps to build the datawarehouse?

What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh

What is a source qualifier?

What is dimensional modelling?

What are the data types present in bo? What happens if we implement view in the designer n report?

What is difference between Mapplet and reusable transformation?

What is data stream and data adaopter. Is it same are different? Explain?

What is drill-through?

Is there any rownum object from which we can do this?

Can we take backup when the database is opened?

What is the difference between olap and oltp?

What is surrogate key? Explain with examples.

For more Data Warehouse General Interview Questions Click Here