Interested to Buy Any Domain ? << Click Here >> for more details...
What is staging area?
- 9 Answers
- 17608 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pradip sahoo
A staging area is where data is processed before entering
into the data warehouse. You need to clean and process the
data before putting it into a warehouse. Cleansing means
removing extra spaces, deleting null values from primary
key columns, etc.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / reetesh jain
Yah its right.
Want to add some point in it.
Basically Staging Area is the mirror image of the warehouse.
And during this stage creation of FACT & DIMENSION table
comes into the picture.
Please let me know if any point is missing.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / pratap gangula
Staging Area disconnects the data from Real time OLTP applications. Since OLTP systems are burdened with transactions, to avoid the OLTP slow downs during processing it is important that we mirror image the OLTP database before we start data transformations(Cleaning & Conforming) for warehouse.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / sreekanth
Staging area is the place where data is tested for its
correctness , dta is cleaned before it goes to warehouse.
simple live example:
water filter.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / harish
Its an intermidiate stage where data is put before its put
into the Datawarehouse database.It is also called
Operational Data Source(ODS).If a report is needed very
urgently though its not a nice one to have then we can
generate from the staging area or ODS.
Ex: if i am so hungry that i cannot wait until my food is
cooked i can have it though it does not taste good.but
because i am too hungry i would not mind that taste.later
once its cooked i can enjoy it much better.
that was just to give an understanding of the concept.
any one please correct me if i am wrong.
Regards,
HARISH.
| Is This Answer Correct ? | 8 Yes | 8 No |
THE STAGING AREA IS NOTHING BUT WHERE THE DATA IS CONVERT
FROM INCONSISTENT FORM TO CONSISTENT
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / radhakrishnan vaithilingam
The staging area is used to travel the data between Source
sytem to Data wareshoue or datamart.
it should be important when we are extracting more than one
source sytem.
The staging will help us to do the cleansing and converting
the data to understaing the business team.
Bridge between source to data warehouse or Data mart.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain me what are data marts?
Difference between e-r modeling and dimentional modeling?
Explain can a dimension table contains numeric values?
Explain the different types of data warehousing?
What are templates in which way it is help full?
What is hybrid slowly changing dimension?
After the complete generation of a report who will test the report and who will analyze it?
What is index awareness in universe?
Can we start and stop single session in concurent bstch?
What is Analysis Services?
Explain why should you put your data warehouse on a different system than your oltp system?
How can we run the graph?
Teradata 
