What's the Main Function of the Staging area in DWH
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
what is factless fact table?
How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What are the enhancements made in datastage 7.5 compare with 7.0?
What are routines in datastage?
What are the differences between datastage and informatica?
What are the main differences you have observed between 7.x and 8.x version of datastage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
source contains 2 columns comes to target 4 columns how
i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
how to remove duplicates in transformer stage by using stage variables?one example?
Name the different sorting methods in datastage.
how many types of remove the duplicate records?