What is staging area is it a Data Base, if so which Data Base.

  • Interview Candidate
  • 28
  • 3819

Showing Answers 1 - 28 of 28 Answers

srinivasable

  • Dec 11th, 2006
 

Staging area is a database.The database may be any database either Oracle, Sql server or DB2.

  Was this answer useful?  Yes

lakshmi

  • Dec 11th, 2006
 

hi,

Staging area is a data base.

  Was this answer useful?  Yes

Manisha

  • Dec 14th, 2006
 

Staging Area is indeed a Database. It is the 'place' where input data from various (possibly hetrogenous) sources can be brought together in one place before performing cleansing or Transformation Rules.

  Was this answer useful?  Yes

Samba

  • Dec 21st, 2006
 

Staging area is a temporary database for transforming the data.

  Was this answer useful?  Yes

Sravan Kumar

  • Dec 21st, 2006
 

Staging area is a tempreray database..Where data transformation activities tacks place.The type what ur using for Your DW.

  Was this answer useful?  Yes

rma

  • Dec 25th, 2006
 

Staging area is the place, where ur hold tables temporarly to perform cleansing to eliminate redundency and transform to warehouse this is connected to sources and wherehouse, this is also type of Database only

  Was this answer useful?  Yes

pavan

  • Jan 24th, 2007
 

I am having very little experience on Informatica but I came across this sentence so thought of writing it down.An OPERATIONAL DATA STORE MAY BE USED FOR DATA STAGING.

  Was this answer useful?  Yes

noverino

  • Feb 22nd, 2007
 

Staging area is temporary area used by ETL to do "Transformation" process. It could be anything, namely database, flat file, memory (cache), complex file, etc. In ETL, there's minimal 3 area: Source, Staging, Target (DW/DM).

  Was this answer useful?  Yes

malla reddy pannala

  • Jul 25th, 2011
 

staging area is just like parking area before we entering the dwh here we doing here collecting the data from various data bases like oracle,db2, teradata to a single data base any of them, remove duplicates or null values (cleansing), scrubbing(adding new columns), merging(vertical or horizontal ).this data send to source in dwh area.
using staging we can do incremental loading,if session fails we can get the data from staging area.

  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