Landing Area VS staging area

I just want to know more about landing area in Datawarehouse
Why landing area required in DWH ?
Diff between landing area and staging area in DWH ?

Questions by cbasavar

Showing Answers 1 - 2 of 2 Answers

Jasmeet Sahni

  • Jan 29th, 2017
 

Landing area - is the area where we kept the source files from where the ETL tool will be going to extract the data.

Staging area is the initial stage of the database where we just load the load into table without applying any transformation or business rules.

  Was this answer useful?  Yes

Suresh Reddy

  • Sep 28th, 2017
 

Landing Area or Landing zone:
This area is used to bring data from multiple source to single zone (say like ODS).
Staging area:
In this area, logics are applied on the data by creating views.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions