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 the use of Row generator stage?
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
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
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?
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?
how does work server jobs?
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?
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.
How many types of hash files are there?
What are the differences between datastage and informatica?
how can find maximum salary by using Remove duplicate stage?
how do u capture duplicates through sort & transformer