What is staging area?

Answers were Sorted based on User's Feedback



What is staging area?..

Answer / haritha reddy

It is the temparory storage area where the reconcilation of
data is possible.
you can extract the data from diff source systems and
transform,you can aggregate, cleans the data.
staging area reduce the burden on the source system.

Is This Answer Correct ?    18 Yes 1 No

What is staging area?..

Answer / mln

This is temporary area where the data is kept for
transformation and clensing.

Is This Answer Correct ?    8 Yes 1 No

What is staging area?..

Answer / anju

staging area is used to integrate data from various
heterogenous sources. the advantage is recoverability. ie
if load session fails we can get data from staging area.

Is This Answer Correct ?    7 Yes 0 No

What is staging area?..

Answer / sai suresh

Staging area is a where data transformaions takes place. It
is temparly storage area . Transformations like "DATA
SCRUBBING, DATA CLEANSING,DATA AGGREGATION,DATA MERGING"
The above transformations are takes place in the staging
area, in staging area data transformed from one format to
required business format then it will load into the target.

Is This Answer Correct ?    5 Yes 0 No

What is staging area?..

Answer / tapsi

staging area is the place where data is collected from the
different sources and it was cleansed and made ready for
transformations.

Is This Answer Correct ?    2 Yes 0 No

What is staging area?..

Answer / mkselva

A place where data is processed before entering the
warehouse

Is This Answer Correct ?    1 Yes 0 No

What is staging area?..

Answer / k raju

Staging area is we kept all data From OLTP with offline mode
in staging area where we made datacleansing and ready for
transformation

Is This Answer Correct ?    1 Yes 0 No

What is staging area?..

Answer / simon

Staging area is a place where you hold temporary tables on data warehouse server. Staging tables are connected to work area or fact tables. We basically need staging area to hold the data, and perform data cleansing and merging, before loading the data into warehouse.

you can refer dwhlaureate.blogspot.com

Is This Answer Correct ?    1 Yes 0 No

What is staging area?..

Answer / lakshminarayana

intermediate area between source system and data warehouse.it is temporary schema/user.after completion of each session we have to delete the previous data from staging area(table) before going to load data into staging area.it is used mainly for the purpose of increase the performance of source system means we perform join condition it will take lot of time to execute because join perform on the total data of table.but staging area required particular condition data means it required small amount data not the total copy of source data.and it used for clean the data before loading.it is relational data base.no end user can't access the data and no transformation perform on the staging area.if the session will failure then we directly receive particular data from staging area.means we can decrease the burden on source by using staging area.

Is This Answer Correct ?    1 Yes 0 No

What is staging area?..

Answer / giri

Staging area is collection of database. It is temporary storage

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More Informatica Interview Questions

what is bridge tables in informatica

1 Answers   CTS,


Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

3 Answers   CTS,


from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic

21 Answers   Deloitte,


What is the difference between Normal load and Bulk load?

5 Answers  


explain different levels in pushdown optimization with example?

2 Answers   TCS,






I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers  


hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.

2 Answers  


3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?

7 Answers   Accenture,


Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 Answers  


wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,


What are ETL Tools?

0 Answers   Informatica,


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

0 Answers  


Categories