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.

Answer / mln

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

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.

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.

Answer / tapsi

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

Answer / mkselva

A place where data is processed before entering the
warehouse

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

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

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.

Answer / giri

Staging area is collection of database. It is temporary storage

what is diff between grep and find

3 Answers   IBM, iFlex,

What is joiner transformation in informatica?

0 Answers  

What does role playing dimension mean?

0 Answers  

What is the query to find nth highest salary? What is the use of cursors?

8 Answers   Keane India Ltd,

What is a filter transformation?

0 Answers  

how to read data from website into informatica? plsss send answers ASAP thanks in advance.

1 Answers   DELL,

What is rank transform?

0 Answers  

what are the differences between powercenter 8.1 and powercenter 8.5?

2 Answers  

I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers   IBM,

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,

What are the different ways to implement parallel processing in informatica?

0 Answers