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

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  


Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 Answers   Cap Gemini, IBM,


there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

1 Answers   Virtusa,


How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?

1 Answers   IBM,


I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?

7 Answers   CTS,






how does work server jobs?

1 Answers  


How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

0 Answers   Wipro,


Hi every one, I am Suneel. I/p o/p --- ----- suneel suneel suneel suneel suneel suneel how it will get. Please design job with explain. Thanks.

4 Answers   Amdocs,


How many types of hash files are there?

0 Answers  


What are the differences between datastage and informatica?

0 Answers  


how can find maximum salary by using Remove duplicate stage?

5 Answers   IBM,


how do u capture duplicates through sort & transformer

4 Answers  


Categories