2.What is staging area ?

Answer Posted / chandrasekar

Staging area is a nothing but storage area or parking area
to store the multiple source date. It will
transform,combine, cleanse data,do the simple business logic
and prepare the source data for datawarehouse.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the design methods of data warehousing?

511


Explain what is cost benefit analysis (cba)?

542


How can you clear the cache?

529


Explain difference between view and materialized view?

507


What are the types of partitioning?

576






Explain which columns go to the fact table and which columns go the dimension table?

520


what type of raid setup would you put your tx logs?

530


How to generate iqd file from framework manager?

525


what are different storage options supported by oracle ?

1606


Is union transormation is active transformation?

590


Explain the hierarchies level data warehousing.

512


What is the use of dimensional modeling in data warehousing?

542


Explain me what are conformed dimensions?

539


Explain what are the different methods of loading dimension tables?

509


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

546