What is staging area?

Answer Posted / harshad

Adding few points

You can use stagin area for your transformation befor it
load it in DW. Also It could be de normalised way then
linked with Dimension to load Fact.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how many ways you create ports?

617


How to generate iqd file from framework manager?

527


What are steps we have to follow in designing the userfriendly universe?

556


What is is a star schema?

570


Explain what are data marts?

592






How many project sources we can create in metadata?

561


Explain the main differences between star and snowflake schema?

546


Explain bus schema?

549


Explain reference cursor?

1700


Explain grouped cross tab?

2197


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

476


Explain is olap databases are called decision support system true/false?

558


explain about balanced dimension,

564


Explain what is the difference between powerplay transformer and power play reports?

642


What are the tools available for etl?

546