Interested to Buy Any Domain ? << Click Here >> for more details...
What is staging area?
- 9 Answers
- 17362 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 are aggregate tables and aggregate fact tables?
What is "method/1"?
What is critical column?
Explain the difference between view and materialized view?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
What are the different methods of loading dimension tables?
What is a Data Cube?
What is surrogate key? Where we use it explain with example?
What is the use of dimensional modeling in data warehousing?
Teradata 
