What is staging area?
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 is difference between Mapplet and reusable transformation?
Which are the olap tools available that are supported by oracle?
What are the key features of chameleon that separates it from other algorithms?
What is Data purging?
what are relationships?
0 Answers InfoAxon Technologies,
How can we import and export using BCP utility?
What is an error log table in informatica occurs and how to maintain it in mapping?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
What is a relationship?
Explain what are the various methods of getting incremental records or delta records from the source systems?
Explain difference between view and materialized view?
What is Active Datawarehousing?