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

How many repositories can we create in Informatica?

Explain what is difference between query studio and report studio?

Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?

Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

When should one use an MD-database (multi-dimensional database) and not a relational one?

What are the differences between datamart vs. Reporting cube?

Explain me what are conformed dimensions?

What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

What is the difference between olap and datawarehosue?

What is meant by metadata in context of a data warehouse and how it is important?

What is the definition of cube in datawarehousing?

After the generation of a report to whom we have to deploy or what we do after the completion of a report?

For more Data Warehouse General Interview Questions Click Here