Interested to Buy Any Domain ? << Click Here >> for more details...
What is staging area?
- 11 Answers
- 27011 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / mln
This is temporary area where the data is kept for
transformation and clensing.
| Is This Answer Correct ? | 8 Yes | 1 No |
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 |
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 |
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 |
Answer / mkselva
A place where data is processed before entering the
warehouse
| Is This Answer Correct ? | 1 Yes | 0 No |
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 |
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 |
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 |
Answer / giri
Staging area is collection of database. It is temporary storage
| Is This Answer Correct ? | 2 Yes | 2 No |
can we use union transformation in joiner transformation?how?
1 Answers Dabur, Tech Mahindra,
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How are indexes created after completing the load process?
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
HOW DO YOU CONNECT TO REMOTE SERVER ?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Write the unconnected lookup syntax?
Difference between task flow and linear task flow
when will we go for unconnected lookup transformation in Informatica?
how to join two flat files in informatica?
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Teradata 
