Interested to Buy Any Domain ? << Click Here >> for more details...
What is staging area?
- 9 Answers
- 17028 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 |
What function should we use to display the value entered or selected by a user in response to a prompt?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
How to handle multi value dimensions?
Explain what is cost benefit analysis (cba)?
How did you plan your Data ware house project?
What are the key columns in Fact and dimension tables?
Difference between ODS and Staging
What is Drill by? drill through?
What is XMLA ?
what is the difference between MOLAP and ROLAP?
What is loop in data warehousing?
What is called data cleaning?
Teradata 
