1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

What's the Main Function of the Staging area in DWH

Question Posted / wed elmahdi

Answers were Sorted based on User's Feedback



What's the Main Function of the Staging area in DWH..

Answer / erwa

Preparing the Extracted Data to be loaded to the DWH.
Preparing like examine each extracted file, review the
Business rules, perform the various data transformation
functions, resolve inconsistencies, Sort & Merge data, etc.

Is This Answer Correct ?    25 Yes 6 No

What's the Main Function of the Staging area in DWH..

Answer / saikiran katari

staging area is a temporary storage area.which is loaded with all the transaction data and while loading in to staging area we are not suppose to perform single transaction activity..
if i am telling is wrong..send me current answer my mail..
mail id: katari079@gmail.com

Is This Answer Correct ?    8 Yes 0 No

What's the Main Function of the Staging area in DWH..

Answer / chandan.g

STAGING AREA is nothing but a temporary memory (resting area ) of the data which is converted initially from the source we get and can be converted into the desired format

Is This Answer Correct ?    6 Yes 1 No

Post New Answer

More Data Stage Interview Questions

What is the use of Row generator stage?

2 Answers  

tell me abt Datastage trigger?

1 Answers   HP, IBM,

what is a nodemap constraint

2 Answers   IBM,

Which warehouse using in your datawarehouse

0 Answers   IBM,

How to reverse the string using SQL?

0 Answers   CTS,




what is difference between migration project and integration project? can anyone explain with the example Thanks in advance

2 Answers   Satyam,

Why do we use link partitioner and link collector in datastage?

0 Answers  

What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?

5 Answers   SLK Software,

what is the diff between sequential file and fileset stages?

3 Answers  

What is diff between Junk dimensions and conform dimension?

4 Answers   Polaris,

Distinguish between informatica & datastage. Which one would you choose and why?

0 Answers  

HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com

5 Answers   FIS,

For more Data Stage Interview Questions Click Here
Categories