RE: What is staging area is it a Data Base, if so whic...
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.
RE: What is staging area is it a Data Base, if so whic...
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
RE: What is staging area is it a Data Base, if so whic...
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.
RE: What is staging area is it a Data Base, if so whic...
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).
