Interested to Buy Any Domain ? << Click Here >> for more details...
What's the Main Function of the Staging area in DWH
- 3 Answers
- 14328 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 |
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?
Is there any possibility to generate alphanumeric surrogate key?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Wat is isolation level and when do u use them?
how to closeing records after 10,000 records come?
how many rows sorted in sort stage by default in server jobs
What is ibm datastage flow designer?
On which Dimension Table you implemented SCD Type in your Project
What is the difference between operational data stage (ods) and data warehouse?
Where do the datastage jobs get stored?
I have the following columns in the EMP table Empid,Empname,Sal,month(Sal),year(Sal) and DOB(let us say the dob is 15th-Jan-1981) Desing a job such that the output contains the following empname,year(sal),tot(sal) and current age i.e. whether 18yrs or so on
Teradata 
