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 |
which unix commands mostly used in datastage
I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
can explain wt is the pool for file.
in oracle target stage when we use load option and when we use upsert option?
hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(
Define oconv () and iconv () functions in datastage?
What is ds designer?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Could anyone give brief explanation bout datastage admin
what is set mapping in datastage??
What's the Main Function of the Staging area in DWH
Is there any possibility to generate alphanumeric surrogate key?