Interested to Buy Any Domain ? << Click Here >> for more details...
What's the Main Function of the Staging area in DWH
- 3 Answers
- 14566 Views
- Oracle, I also Faced
- E-Mail Answers
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 |
How can we move a DATASTAGE JOB from Development to Testing environment with the help of a datastage job using unix commands.
I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?
What is Fastly Changing Dimension?
Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises
What are constraints and derivations?
Triggers,VIEW,Procedures
what is the main differences between Lookup, Join and Merge stages?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
On which Dimension Table you implemented SCD Type in your Project
What are operators in datastage?
I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????
Differentiate between hash file and sequential file?
Teradata 
