1 Source to Staging Area 2 Staging area to work space 3 Work Space to dat

Explain Process flow in data warehouse??

Question Posted / parvar

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How to know the time taken for particular report execution?

908

Where we use surrogate key explain with example?

1047

Name a few sectors which use data warehousing?

880

Explain what is a three tier data warehouse?

911

Explain what is the main difference between inmon and kimball philosophies of data warehousing?

921

Explain what are the different types of join operations?

916

What are the different ways to represent the loading of dimension tables?

882

Suppose we want to display zero when null values coming to report how can we do that?

865

Explain what are slowly changing dimensions?

969

Code the tables statement for a single-level (most common) frequency?

881

How are the dimension tables designed?

932

What is data stream and data adaopter?

1022

Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

904

What is the difference between dependent data warehouse and independent data warehouse?

939

Explain is fact table?

878