Interested to Buy Any Domain ? << Click Here >> for more details...
What's the Main Function of the Staging area in DWH
- 3 Answers
- 14437 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 |
What are operators in datastage?
which is more expensive hash or modulus partitioning? when do you use modulus partitioning?
How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
In merge stage can we update the values?
i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance
How a server job can be converted to a parallel job?
Nls stands for what in datastage?
What is the differentiate between data file and descriptor file?
IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
What r the existing server jobs in parallalism?
Teradata 
